Excel VBA - Userform combox problem

T

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
 
T

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.
 
Top