PDA

View Full Version : Solved: validate Combo boxes



SeanJ
08-20-2008, 09:57 AM
Hey Guys,

I have 2 combo boxes that are located on a userform. The 1st combo box the list is created when the form is activated. and the second combo box is when a a date is chosen in date picker. Both combo boxes show blank when the form is loaded. I want to run a validation on each combo box if the user clicks the down arrow and doe not like the choices and leaves it blank. I am stumped :banghead:!!

Bob Phillips
08-20-2008, 10:29 AM
Check ListIndex, it will be -1 if no selection is made.

SeanJ
08-20-2008, 10:40 AM
Thanks for your help I should have known that. :banghead: That is what happen when I don't code much.