Combo box within Userform

[wilwhiting]

I have userform with mostly textboxes except for a combo box i am trying to use. I want to be able to limit the user selection to a selected number of choices.

This is all the code i have so far for this userform.

Please Login or Register  to view this content.

[royUK]

You don't use AddItem on the combox_change. You load the combobox on initialising the form.

[wilwhiting]

I tried using Userform_Initialize() before instead on combox but i throws the 424 error. I am unsure to what i am actually doing wrong, please can you expand on your last comment.

[Kenneth Hobson]

Without seeing your code, it is hard to see what may be wrong.

You can set the MatchRequired=True in the control or in the Initialize event.

Please Login or Register  to view this content.

[wilwhiting]

Thanks, working great now!