Combo Box Data Validation?

[leffiegrl]

Hi guys,

I am new here and wondered if someone could help. I have created a UserForm, which is working perfectly, apart from one aspect that I can't figure out how to do.

I have some Combo Boxes with set data which I have populated using the RowSource section of the Properties box. However, this doesn't seem to prevent my users from typing over these options and inputting data with something that is not on the list.

How can I stop this happening?

Thank you in advance!

[davegugg]

There is a combobox property called MatchRequired. Set it to true.

[leffiegrl]

I knew I was doing something silly wrong!

Thank you very much.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[snb]

You'd better change the style property to 2-dropdownlist.