Data validation on combobox in userform

Hi again guys, I need some help with data validation on my comboboxes in my userforms.

I'd like it to work so that my comboboxes are validated and that no other information but the lists provided can be entered into the boxes.

Also, is there a way to get the "Begin" button on Sheet1 to recognize the last used UserForm? This is only if they need to stop the timer for whatever reason and have to get off the UserForms to do so. I'd like them to be able to return to their last used UserForm.

Originally Posted by zamirkaya

I'd like it to work so that my comboboxes are validated and that no other information but the lists provided can be entered into the boxes.

Something like this in each combobox event

Please Login or Register  to view this content.

Also, is there a way to get the "Begin" button on Sheet1 to recognize the last used UserForm? This is only if they need to stop the timer for whatever reason and have to get off the UserForms to do so. I'd like them to be able to return to their last used UserForm.

You will need to store a userform value (1 or uf1 of Userform1) on the sheet. (Below the answers would be a good spot.)

When the test is started again, ask the user if they want to continue. If yes, check the value and call the appropriate userform. (Be sure to clear the value when the last form loads.)

Just curious, why do you have 15 (seemingly) identical useforms?

Couldn't you list the questions on a sheet an use one userform?

That could make things a lot easier, in particular going back to the previous question.