validation and combobox entries (1 Viewer)

[Geordie2008]

Afternoon all,

I have a combobox so the user can select values that are valid.

I only just realised that the can type directly in the cell and ignore the values in the drop down if they want (eeek!)

How do I MAKE the user select a value from the drop down and not be able to type anything else into that combobox?

Many many thanks for help, cant believe I only just noticed they have been doing this! And I cant believe how sneaky my users are (!!)

Mandy

 

[gemma-the-husky]

there is a limit to list property - set that to true

 

[Geordie2008]

Genius, thanks!