Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values of cells in a comment
MS Excel 2003
I'm writing a macro that will insert a comment in a cell based upon the cell value. For instance, A B C D E 1 Address City State Phone 1 What I want to happen is that if E1 = 1 then Insert a comment in cell E1 as follows: A1 B1, C1 D1 to read Street City, State Phone I've got the AddComment working, but how do I pull the values of A1-D1 to use as text in the comment? Any help would be appreciated, thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel Paste Special Values Deletes Comment | Excel Discussion (Misc queries) | |||
Using values of cells in a comment | Excel Programming | |||
can i attach the same comment to different cells | Excel Discussion (Misc queries) | |||
how can i automatically insert cell values into a comment field? | Excel Discussion (Misc queries) |