combobox with msgbox in excel

[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...

[si_the_geek]

Welcome to VBForums

Thread moved from the 'Database Development' forum (which is for questions about SQL/tables/etc) to the 'Office Development/VBA' forum

[westconn1]

perhaps like

If cboCategory.text = "Select Category..." or cboCategory.text = "" Then
    MsgBox "All Fields are Required!"
    exit sub
End If

[kaliman79912]

It depends on many things, the two main being where in code is your validation, and where in your code do you put the value in a cell. If what you are doing (most likely) is to have the combobox directly connected to the cell via the LinkedCell property then don't, and handle its value (Cell(r,c)=txtWhatever.Value) after the OK button is pressed.

hmm just noticed you say you have a user form. I believe textboxes in userforms do not have the LinkedCell property, so just handle the value after the validation has been done.

[westconn1]

hmm just noticed you say you have a user form. I believe textboxes in userforms do not have the LinkedCell property,

judging by the name it is a combobox, not a textbox, which has a rowsource, but there is no indication if it is being used, looks like a submit commandbutton is to be used when all boxes are filled

[kaliman79912]

The current control appears to be a combobox, But the value passed to the cell, OP stated it is a textbox. Never the less, the same principle stands.

[hensucker]

The check entry for the combobox needs to be placed before the code that submits the data to the active sheet, this way it checks that everything is good to go and if happy it will enter the data to the sheet.