Limit users to combobox list

[MFish]

I have the property set to, "Match Required" for my comboboxes. I have a clear button that resets all of the values of my comboboxes to nothing, "". It keeps saying the selection is invalid after the clear button is pressed. I'll then fill out the form with the correct information and I'll hit submit, or just exit the userform, and the same message prompts me. How do I get this to stop popping up after the clear button is used or moving forward?

 

[Kamolga]

Maybe

[LEFT][COLOR=#000000][FONT=monospace]Application.DisplayAlerts = [/FONT][/COLOR][COLOR=#07704A][FONT=monospace]False[/FONT][/COLOR][COLOR=#000000][FONT=monospace] [/FONT][/COLOR][/LEFT]

 

[MFish]

Well, I still need the alerts to display if something is accidentally left blank. Any other way?

 

[Fluff]

You can do something like

[COLOR=#ff0000]Dim DisableEvents As Boolean[/COLOR]

Private Sub ComboBox2_Change()
   If DisableEvents Then Exit Sub
   'your code here
End Sub

Private Sub CommandButton1_Click()
   DisableEvents = True
   'your code here
   DisableEvents = False
End Sub

The line in red needs to go at the very top of the module, before any code.

 

[Kamolga]

Create your MsgBox if something is left blank with focus to that place, so as a user you do not even need to look what is wrong...or simply use

[FONT=monospace]Application.DisplayAlerts = [/FONT][COLOR=#07704a][COLOR=#07704a][FONT=monospace][FONT=monospace]True[/FONT][/FONT][/COLOR][/COLOR]

after your line