Excel VBA - Userform combox problem
 

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/

Excel VBA - Userform combox problem
 

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/

Excel VBA - Userform combox problem
 

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/

Excel VBA - Userform combox problem
 

Thank you both very much.
Nic

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