Dropdown not allowed to be enter other values

[Guest]

Hi all,

How to make a dropdown not accept other values not in the dropdown list?

Clara

 

[Susan]

User Editing of Drop Down Box Data
http://groups.google.com/group/micr...ata+to+dropdown&rnum=1&hl=en#60f4075e35169bf9

search the newsgroup & you might find the answers you need....... but
maybe not.

susan

 

[Guest]

Is this on a sheet - personally I use data - Validation, rather than
controls...