Tooltip on form buttons?

[carrot rope]

Hi all,

I'm creating an interface for a school mark book in Excel which uses form buttons to let the user navigate around. What i'd ideally like though is some form of tooltip or comment to popup when the user passes over the button in question. Does anyone know of how/if this can be done?

Thanks in advance,
carrot.

 

[Mudface]

As far as I know, you can't have tooltips for buttons or controls placed directly onto the worksheet, like you can for userforms.

You can though if you first draw a frame (you might have to click on the More Controls button on the Controls Toolbar and browse down to find it under MS Forms 2.0 Frame) and then right-click on it and choose Frame Object-Edit. This will bring up a separate Toolbox similar to that used for userforms, buttons placed onto the frame have a ControlTipText property which can be modified to show the text you wish.

 

[Ivan F Moala]

You can use the Commandbutton controls from the ActiveX controls and use some API calls to simulate the Tool tips.....otherwise use Mudfaces good suggestion....although programing it is a little *diff*