I have a similar question.
How do you restrict a text or comobox control, on a user form, so that only
certain data can be entered?



"Jim Thomlinson" wrote:

You want to add cell validationl. Select Data - Validation and in the drop
down list select the data type you want. On the other tabs you can define how
you would like to handle input errors...
--
HTH...

Jim Thomlinson


"SmartyPants" wrote:

How do you restrict a cell so that only certain data can be entered?

For example: I need to protect a cell in a fashion that only a date can
be entered.

I'm having problems with people entering formulas in for the date and I
want to restrict them from doing this (it messes up everything).

Any help would be appreciated

thanks