Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Attach comment to object
Hi,
Is it possible to attach either a comment or screen tip to either a button, picture or drawing object? I tried applying a comment to the cell behind the button, but that doesn't seem to work. Any assistance gratefully received |
#2
|
|||
|
|||
Neil-
You could pop up a message box when the object is clicked. For example, I created an autoshape (a star) on my worksheet. Then I right-clicked on the autoshape, Assign Macro, and clicked "New". Then just insert code like: MsgBox "This is a star!" The macro should look something like: Sub AutoShape3_Click() MsgBox "This is a star!" End Sub --- HTH Jason Atlanta, GA "Neil Jimack" wrote: Hi, Is it possible to attach either a comment or screen tip to either a button, picture or drawing object? I tried applying a comment to the cell behind the button, but that doesn't seem to work. Any assistance gratefully received |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding default comment text | Excel Discussion (Misc queries) | |||
Hotkey problem w/ macro to append comment | Excel Discussion (Misc queries) | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
comment indicators should feature lock or pw protect limiting acc. | Excel Worksheet Functions |