MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Choise if Control Tip Text are shown in VBA form?


Posted by Pasi Vartiainen on September 11, 2000 6:27 AM

Is it possible to ask user if he wants to see control tip text in userform? I have file which some people use daily, and other people just once in a month. For those, who use form daily, it's annoying to see flash of yellow box appear every time they move mouse around. I ask, is it possible to make promt, for example with msgbox, to ask wheather user wants control tip text to be shown?


Posted by Ivan Moala on September 12, 0100 12:58 AM


Yes you can
Try something like this in your userform initialize event
OR something similar.
You could also put and option button on your userform
and intiate it this way.

Private Sub UserForm_Initialize()
Dim Obj As Object
Dim TextOnOff As Integer

TextOnOff = MsgBox("Turn text Off (Yes) or On (No)", vbYesNo)
If TextOnOff = vbYes Then
For Each Obj In Me.Controls
Obj.ControlTipText = ""
Next
End If

'The rest of your code

End Sub

HTH

Ivan