Can a tooltip be added to a button on a custom toolbar in
Excel?

Hi David,

Do the following:

1) Right click on your custom toolbar and select 'Customize'.
2) Right click the button on your toolbar that you want to set the
tooltip.
3) Under "Name:" type in your tooltip.
4) Close the "Customize" window and test it...

Cheers
Zantor



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

it's a standard property of a commandbar control.

normally when you set the caption of a commandbarcontrol this is copied
to the tooltiptext, but you can subsequently set the tooltiptext
seperately.


This does not apply to controls on a worksheet.

You could enter a comment in the cell below the control.
I've used BottomRightCell to avoid overlap (Z-order) problems.
but TopLeftCell.Offset(,1) should work as well. Depends on sizing.

Private Sub CommandButton2_GotFocus()
Me.CommandButton2.BottomRightCell.Comment.Visible = True
End Sub
Private Sub CommandButton2_LostFocus()
Me.CommandButton2.BottomRightCell.Comment.Visible = False
End Sub


Following wont work with the controls you want, but may be an
alternative:

if you just want a handy tooltip in a cell..
you can set a "dummy" data validation with just the "input message" tab
filled in. then.. when a user activates that cell he gets the message :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"David" wrote:

Can a tooltip be added to a button on a custom toolbar in
Excel?

Should there be a 'caption' option when a tooltip on a custom toolbar is
right clicked in customised mode?

The options I am getting in Excel 2002 a

Reset, Delete, Name, Copy Button Image, Paste Button Image,
Edit Button Image, Change Button Image,
Default Style, Text Only (Always), Text Only (In Menus),
Image and Text, Begin a Group, Assign Hyperlink, Assign Macro.

David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Zantor already told you to use the Name

--
Regards,
Tom Ogilvy

David WIlliamson wrote in message
...
Should there be a 'caption' option when a tooltip on a custom toolbar is
right clicked in customised mode?

The options I am getting in Excel 2002 a

Reset, Delete, Name, Copy Button Image, Paste Button Image,
Edit Button Image, Change Button Image,
Default Style, Text Only (Always), Text Only (In Menus),
Image and Text, Begin a Group, Assign Hyperlink, Assign Macro.

David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!