check empty fields in userform

[ogo]

Hi all,
I have a userform with lot of comboboxes of which some are visible. What I need to do is I have to check if there is any empty field and if possible highlight the field..Is it possible??

 

[ogo]

Anyone knows a way to check visible and empty comboboxes??

 

[AlphaFrog]

Try something like this...

    Dim ctl As Control
    
    For Each ctl In Me.Controls
        If TypeName(ctl) = "ComboBox" Then
            If ctl.Value = vbNullString And ctl.Visible Then
                ctl.BackColor = RGB(255, 255, 153)  ' Light Yellow
            Else
                ctl.BackColor = vbWhite
            End If
        End If
     Next ctl

 

[ogo]

Thank you so much Alpha..