PDA

View Full Version : Solved: ToolTip for VBA checkbox in Excel



slooftsuj
12-13-2006, 02:09 PM
I have several user forms that I created that have a combination of checkboxs, lables, textboxs and commandbuttons. I want to be able to display tooltips for them when the mouse passes over them to give a brief description on what they are for. How do I accomplish this in Excel VBA?

Thanks,
Ross

Norie
12-13-2006, 02:17 PM
Ross

Use the ControlTipText property.

Simon Lloyd
12-13-2006, 02:22 PM
Use ControlTipText found in the properties window for the object!

Regards,
Simon

EDIT: Oooops "Snap" Norie!

slooftsuj
12-13-2006, 02:23 PM
Norie,

Thank you. So easy it should have slapped me in the face.