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/