Make an Input box on a Userform Required and change colour when completed

tigerdel · Nov 25, 2014

Hi All

I have a Userform with a number of Required Text fields and drop down boxes

I would like them to have a backcolor of yellow until an entry is added and then return to white

Any ideas how I can make the fields required and have the color scheme?

Thanks all

D

pike · Nov 26, 2014

tigerdel

something like

Code:

Private Sub ComboBox1_Change()
    If Len(Me.ComboBox1.Text) > 0 Then
        Me.ComboBox1.BackColor = vbWhite
    Else
        Me.ComboBox1.BackColor = vbYellow
    End If
End Sub

Make an Input box on a Userform Required and change colour when completed

tigerdel

New member

pike

New member