| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having input the current date in a cell I want to lock it
There's no event that fires when a data form closes, so you're probably
going to need to use a userform instead. In article , Jim Mc <Jim wrote: I am running a macro to check info inputted by the form command. I want to add the date and time at the moment the form is closed. I can do this but the date and time changes as time moves on. How can I lock this data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date label and current date in same cell | Excel Discussion (Misc queries) | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| Can I lock cell contents after current date is past? | Excel Worksheet Functions | |||
| Lock in current date | Excel Discussion (Misc queries) | |||
| Having input the current date in a cell I want to lock it | Excel Programming | |||
Linear Mode
