| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Like Data Validation BUT
Thanks VERY Much Jim
"Jim Thomlinson" wrote: Do the data validation list exaclty as you would normally but go to the error alert tab and uncheck the checkbox "Show error alert after invalid data has been entered" This will give you the drop down but will not throw any kind of error or warning if the user free types. -- HTH... Jim Thomlinson "JMay" wrote: Can i create something very similar to the Data Validation Drop Down, EXCEPT -- be able to Edit the Choice made. I know it defeats the purpose, But I need to give the User the Choice Jan-Dec (drop-down all 12 months), but allow them every once in a while the ability to say EDIT to "Feb-A1", when originally Feb was chosen from the drop-down. This is data-entry and will span thousands of rows.. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Threaded Mode
