| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Restrictions
thanks alot
"Tom Ogilvy" wrote: there is no built in provision for this. You can use events like the change event, afterupdate, or exit events to have your code check the entry and take the appropriate action. Just note the change fires on every keystroke. -- Regards, Tom Ogilvy "ernie" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RESTRICTIONS | Excel Discussion (Misc queries) | |||
| sumif with restrictions | Excel Worksheet Functions | |||
| Excel help and AD GPO restrictions | Excel Discussion (Misc queries) | |||
| How to do look up with restrictions | Excel Discussion (Misc queries) | |||
| Excel Cell Restrictions | Excel Worksheet Functions | |||
Hybrid Mode
