Hi Sala

See if data validation will do what you want:
http://www.contextures.com/xlDataVal01.html

A worksheet isn't really a form in the strict meaning of the word. And
preventing incredible user actions is a complete science of its own. So
you're never 110% safe. But it's easier with a userform + VBA code than with
a worksheet.

HTH. Best wishes Harald

"Sala" skrev i melding
...
I'm in a bind....

I have a form that contains embedded drop down menus (are
they called lists?). I want the users to select an option
from the list but some users are getting creative and
finding ways to put non-list values in the cell. How do I
prevent this?

Sala