| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before Cell Exit
Thanks for taking the time to read my question.
I want to write a function that is executed before the user exits a specific cell. The purpose is to check the format of the date that has been entered, and make the user correct it if it's wrong. The reason is I'm getting stuff like: Mar. 12-2010 12/Mar-10 10-12-Mar 12.2010.03 Some are date formats and some aren't even close... Dates will be in a specific column or specific cell, so I need to execute the function before the user leaves that cell or column. Not sure how to do that. I know in MS Access there is a BeforeUpdate, but don't see anything like that in Excel. Thanks for your help Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exit Field vs Exit Button...... | Excel Programming | |||
| change cell on exit vba | Excel Programming | |||
| How do I exit on blank cell? | Excel Programming | |||
| Macro on exit cell | Excel Discussion (Misc queries) | |||
| If a called sub exit, how to the caller exit right away? | Excel Programming | |||
Threaded Mode
