Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neil Jimack
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding default comment text dshigley Excel Discussion (Misc queries) 1 April 8th 05 05:26 PM
Hotkey problem w/ macro to append comment roadkill Excel Discussion (Misc queries) 1 April 6th 05 06:52 PM
Cell comment boxes shouldn't change size/shape unless changed by u sam Excel Discussion (Misc queries) 1 March 3rd 05 05:23 PM
VBA: Where to find Excel Object model? N. Foldager Excel Discussion (Misc queries) 13 February 6th 05 06:43 PM
comment indicators should feature lock or pw protect limiting acc. summer_rose Excel Worksheet Functions 1 December 3rd 04 07:02 AM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"