Once again - ControlTipText 2

[Mollethewizard]

I take the liberty to post my question once again. Maybe there are more users out there that got the same "problem"...

I’ve got a user form with some textboxes. One of the textboxes has a ControlTipText. Can I put some code in the user form so the ControlTipText appears when the user tabs to the textbox - enters the box?

I do know that the text appears when a user "hover the mouse" over the textbox as LPlates answered to my previous question. "My" users do not enter the particular textbox by clicking it. They tabs between the boxes.

Is there a way to get the ControlTipText to appear when a tab enters the text box?

Christer

 

[Bowers74]

You can't get the ControlTipText to appear that way becasue it will only appear when the user "hovers" over the control with the mouse pointer (check Excel VBA Help on that).

There is a trick that you can do though:

1. Create a Label on your form and set it's Visible property to False.
2. Format the Label to "look like" the ControlTipText
3. Using the Enter and Exit events of the TextBox you control the Visible property of the Lable

Private Sub TextBox2_Enter()
Displays the Label
Label1.Visible = True
End Sub

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
' hides the Label
Label1.Visible = False
End Sub

I know that it seems to be a bit more difficult, but if you set it up right, it will look GREAT!!!

I hope this helps!!!


Peace!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[Mollethewizard]

Mike – why didn’t I think of that solution!

Even if it’s a little bit more coding it’s absolutely brilliant!

You really deserve the star I’ve give to you!

Thanks a lot!

Christer

 

[Mollethewizard]

Now I’ve created an information area in my user form. The area consists of a label that I bring alive when the user enters the textbox and put asleep when he/she exits the box.

I can use the label for more text boxes by changing the caption of the label for each box.

Once again, brilliant, Mike!

Christer

 

[Bowers74]

Glad I could help!



Peace!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[Bowers74]

^^^ Bump ^^^



Peace!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884