Hello!

As you can see in the code below, i am using IF COMBOBOX1.VALUE="" THEN show a textbox warning the user that they can not proceed if they don't fill out COMBOBOX1. Can't complain, it's working perfectly.

Problem: Now i have a Userform where we have 40 textboxes and/or Combobox(es).
Question: Rather than having to specify EACH ONE with code (like in the sample code shown below), is there a way to syntax it so that if ANY of the 40 textboxes or comboboxes value = "" THEN stop the rest of the process and tell the user to please check their work and try again?


...Private Sub CommandButton1_Click()
'the Save button on userform1

If COMBOBOX1.Value = "" Then
MsgBox "hello there.  You can not leave ANY boxes unaddressed.  Please fill out and try again."
End If
Exit Sub

Worksheets("task management").Cells(Rows.Count, 3).End(xlUp).Offset(1).Value = COMBOBOX1.Value
Worksheets("task management").Cells(Rows.Count, 2).End(xlUp).Offset(1).Value = txt_opendate.Value
Worksheets("task management").Cells(Rows.Count, 4).End(xlUp).Offset(1).Value = Txt_Open_Comments.Value

' I have approximately 40 txtbox/comboboxes in here.  shortening for brevity

End Sub

Thanks! Any insight would be appreciated!!

RO