Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking comments to appear in cell at same time
Is it possible to have comments for cells, appear in a seperate cells or
worksheet as data as they are added like link function ? |
#2
|
|||
|
|||
I have tried in some other work a code similar to the following code in vba
Range("d2") = Range("a1").Comment.Text but I am not aware whether it can be linked. perhaps a event code with sheet_change can be attempted. MarkM wrote in message ... Is it possible to have comments for cells, appear in a seperate cells or worksheet as data as they are added like link function ? |
#3
|
|||
|
|||
Saved from a previous post:
You can retrieve the text from a comment with a userdefined function like: Option Explicit Function GetComment(FCell As Range) As Variant Application.Volatile Set FCell = FCell(1) If FCell.Comment Is Nothing Then GetComment = "" Else GetComment = FCell.Comment.Text End If End Function Then you can use it like any other function: =getcomment(a1) But be aware that the function won't evaluate when you just change the comment. It'll be correct when excel recalculates. (Hit F9 to force a recalc.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm MarkM wrote: Is it possible to have comments for cells, appear in a seperate cells or worksheet as data as they are added like link function ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i type a time into a cell formatted for time? | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Can I create a cell that will count by one every time I print the. | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |