highlight textbox when selected

**lifeseeker1019** · 02-10-2014, 05:46 PM

Hi,

what is the VBA code for highlighting the textbox when selected?

I want to have system highlight the textbox when user is inputing the information in that textbox

textbox_gotfocus()?

**AndyLitch** · 02-10-2014, 07:33 PM

If it's a worksheet textbox :-

Private Sub TextBox1_GotFocus()
    TextBox1.BackColor = &HC0FFC0
End Sub
Private Sub TextBox1_LostFocus()
     TextBox1.BackColor = &HFFFFFF
End Sub

If it's a userform :-

Private Sub TextBox1_Enter()
    TextBox1.BackColor = &HC0FFC0
End Sub
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    TextBox1.BackColor = &HFFFFFF
End Sub