Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using values of cells in a comment
Sub ABC()
For Each Cell In Range("E1:E5") If Cell.Value = 1 Then With Cell.Offset(0, -4) s = .Range("A1").Value & _ Chr(10) & Range("B1").Value _ & ", " & Range("C1").Value _ & Chr(10) & Range("D1").Value End With Cell.NoteText s End If Next End Sub worked for me. -- Regards, Tom Ogilvy "Bamaopoly" wrote: 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 | |||
comment in cells they have a little red tringel | Excel Discussion (Misc queries) | |||
2007 Excel Paste Special Values Deletes Comment | Excel Discussion (Misc queries) | |||
link cells to a comment | Excel Discussion (Misc queries) | |||
how can i automatically insert cell values into a comment field? | Excel Discussion (Misc queries) |