I have a form with four combo boxes and then i have a command button which has an on click event to open another form. How can i force the user to select from all four combos and if they leave any combo blank i wana give them an error or some sort of a pop up message saying "all combos" need to be selected. how do i code that in VBA. thanks for ur help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combox box help 1
- Thread starter teachmecr
- Start date
-
1
- #2
just do a if statement to check
If combo1 = " " then
msgbox "your message"
elseif combo2 = " " then
msgbox "Your message
elseif combo3 = " " then
msgbox "Your message
elseif combo4 = " " then
msgbox "Your message
end if
I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
If combo1 = " " then
msgbox "your message"
elseif combo2 = " " then
msgbox "Your message
elseif combo3 = " " then
msgbox "Your message
elseif combo4 = " " then
msgbox "Your message
end if
I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY
- Status
Similar threads
