Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting comment text from VB code
I am needing to have VB code place text into the comment box of a series of
cells. Currently the text to be placed is being retrieved from other areas and being held in a array. At the conclusion of another routine it needs to be placed on a comparison page for comparing a group of choices. I have tried using "Activecell.Comment = Comments(X)" where Comments(X) is the array with the info. However this results in a error "Object does not support this property or method". Honestly I am at a loss on how to acomplish what I am wanting. I have looked in the help documentation but was not able to locate what I need. I appreciate all help given. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
setting comment defaults | Excel Worksheet Functions | |||
setting standard comment size for all rows in a worksheet. | Excel Discussion (Misc queries) | |||
Setting size of comment under macro control? | Excel Programming | |||
comment setting defaults | Excel Discussion (Misc queries) |