VBA pop message box based on certain criteria

[jimmisavage]

I have a userform where I want to make sure the user is inputting the necessary data.

ComboBox41 only needs to be completed IF ComboBox1 has data and ComboBox21 is empty.

So if ComboBox1 is empty we can move on.
Or if ComboBox1 has data and ComboBox21 has data we can move on.

 

[jimmisavage]

No, not exactly.

If combobox1 is empty 21 and 41 can also be empty

If combobox1 has data in it EITHER 21 or 41 MUST have data.

If combobox1 has data and 21 doesn't then 41 MUST have data.

Sorry, its complicated!

 

[Roderick_E]

No, not exactly.

If combobox1 is empty 21 and 41 can also be empty

If combobox1 has data in it EITHER 21 or 41 MUST have data.

If combobox1 has data and 21 doesn't then 41 MUST have data.

Sorry, its complicated!

Yes, you'll need to work out the logic then do your conditional statements. Map it out then I'd suggest doing it up in notepad or something first, then in vba. You could still use my errmsg method so the user only needs to see one popup msg telling them what is needed, but first you need to loop through all the conditions. Good luck.