Excel VBA - Userform combox problem

[thesteelmaker]

How can i protect a combox, on a form, from unwanted data entry.

ie only being able to select whats in the list, and not enter other
text/numbers or leave blank.

Many thanks

 

[Mark Rosenkrantz]

Steelmaker;

Userform1.combobox1.Locked = True

 

[Tom Ogilvy]

If a combobox from the control toolbox toolbar, look at the MatchRequired
property:

From help:

If the MatchRequired property is True, the user cannot exit the ComboBox
until the text entered matches an entry in the existing list. MatchRequired
maintains the integrity of the list by requiring the user to select an
existing entry.

 

[thesteelmaker]

Thank you both very much.
Nic

 

[pgjoshi]

If you don't want to add anything to Combobox then can you use Listbo
instead of Combobox ?

Prasad Josh