Make userform label visible when textbox is selected

[Kiwicoder]

Hi,

I am a newbie to VBA and have a userform question. I have a simple userform that contains a textbox and a label. How do I make the label visible only if the user selects the textbox (i.e. places the cursor in the textbox)? Thanks in advance for your help.

 

[wolverineb]

Set the label's properties to visible = false. Then use this code (double-click on the userform and put this code in the editor that pops up):

Private Sub TextBox1_Enter()
Me.Label1.Visible = True
End Sub

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.Label1.Visible = False
End Sub

 

[Kiwicoder]

That works perfectly. Thanks for your help!