Hi all,
I have built a multipage userform which holds around 50 of different objects, such as textboxes, comboboxes etc. For every single object I have written 2 codes that format that object on entry and exit. How do I make these 2 codes universal for the uniform, so that they kick in when any of 50 objects get focus? It drives me mad to go through 100 codes and do changes!
[CODE][/Private Sub Title_Enter()
If Title.Text = "Title" Then
Title.Text = ""
Title.BackColor = RGB(255, 255, 153)
End If
End Sub
Private Sub Title_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Trim(Title.Text) = "" Then
Title.Text = "Title"
Title.BackColor = RGB(255, 255, 255)
End If
End SubCODE]
I would be so much gratefull if someone could help me out with this issue!
Thanks in advance!
Bookmarks