ComboBox.list = Array Validation problem

Searched for this couldn't find anything that helped.

I have a Combobox that I provide an array for:

Please Login or Register  to view this content.

Problem is, with that Value prompt, some users would be tempted to just hit the number 4 on the keyboard rather than use the combobox. This causes kack. The first ComboBox is the source control for a second ComboBox.

I've toyed with the option of just changing from the combobox but if there is a way to make this work without that...

In an IDEAL world, if the user types the number 1-5 it would automatically set the correct choice, if they typed anything else a message box would pop up. it already works fine if they read my mind and only do what was expected of them in the first place.

Not sure if this can be done, or if more info is needed

Thanks

I tried using List style and it would kack later on when I'm juggling values for navigation.

When the above choice is made it passes on the value to :

Please Login or Register  to view this content.

When List Style is selected it locks at the Revaluing of .LevelSelector.Value = "L5"

Sure thing.

here it is, a bit more than a sample, ATM I'm too brain fried to creatively prune out some of the bits, but I think its clean enough to find what you need.

as you launch the Form, I'd LIKE to have it accept a Number typed in (1-5) but I realize that's probably not an option.

I'm still new to VBA so the Validation thing is still "majic" to me.

I currently understand about 85% of the code in my project but even tho I'm getting better at fixing the stuff that goes "bump", this bit has be fuddled.