Attach comment to object

N

Neil Jimack

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
 
J

Jason Morin

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
 
Top