ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Attach comment to object (https://www.excelbanter.com/excel-worksheet-functions/25764-attach-comment-object.html)

Neil Jimack

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

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

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



All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com