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