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


---
Message posted from http://www.ExcelForum.com/

Steelmaker;

Userform1.combobox1.Locked = True

--
More Excel ? www.rosenkrantz.nl or
-------------------------------------------------------------------

"thesteelmaker " wrote in
message ...
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


---
Message posted from http://www.ExcelForum.com/

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.

--
Regards,
Tom Ogilvy


"thesteelmaker " wrote in
message ...
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


---
Message posted from http://www.ExcelForum.com/

Thank you both very much.
Nic

--
Message posted from http://www.ExcelForum.com