userform with combobox

[ellehcer08]

hi! my userform has a combobox, and i would like to create a msgbox that when that combobox is blank or still has the phrase "Select Category..." will create a msgbox stating that the form is incomplete..

this is my code do far:

If cboCategory = "Select Category..." Then
MsgBox "All Fields are Required!"
Else
End If

This code is fine cause when i hit the OK button, the msgbox appears but the information typed in the other txtbox(same userform) is entered in the active sheet. I like to have a code that WILL NOT enter the information stated in other textbox when the OK button is clicked.

Please help!! Thanks a lot...

 

[AlphaFrog]

Try something like this.

If cboCategory = "Select Category..." Then
    MsgBox "All Fields are Required!"
    [COLOR="Red"]Exit Sub[/COLOR]
End If

Otherwise you should list all your code to illustrate how it all interacts.