Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with cell notes.
Help with cell notes.
Is there a way to get the contents for a cell note from somewhere else in the sheet? I'd like to make a 'lookup table' to generate the note contents. Let me know. Thanks. -- Dab Cut off: yourhead to respond |
#2
|
|||
|
|||
Hi
not without using VBA and creating the cell comments programmatically -- Regards Frank Kabel Frankfurt, Germany "Dab" schrieb im Newsbeitrag ... Help with cell notes. Is there a way to get the contents for a cell note from somewhere else in the sheet? I'd like to make a 'lookup table' to generate the note contents. Let me know. Thanks. -- Dab Cut off: yourhead to respond |
#3
|
|||
|
|||
One would need to use VBA to do so. If you want to go that route, post
back, or look at Debra Dalgleish's site: http://www.contextures.com/xlcomments03.html In article , "Dab" wrote: Is there a way to get the contents for a cell note from somewhere else in the sheet? I'd like to make a 'lookup table' to generate the note contents. Let me know. Thanks. |
#4
|
|||
|
|||
here's one of those VBA solutions.
Option Explicit Function PutComment(myStr As String, TCell As Range) As Variant Application.Volatile With TCell If .Comment Is Nothing Then 'do nothing Else .Comment.Delete End If TCell.AddComment Text:=myStr End With PutComment = "" End Function Then you can use a formula like: =putcomment(VLOOKUP(A1,Sheet2!a:e,2,false),B9) This matches the value in A1 in Sheet2, column A. It returns the second column and plops it into a comment in B9. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dab wrote: Help with cell notes. Is there a way to get the contents for a cell note from somewhere else in the sheet? I'd like to make a 'lookup table' to generate the note contents. Let me know. Thanks. -- Dab Cut off: yourhead to respond -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |