Attach comment to object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top