Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a pop-up calender in a Userform which works fine and which I have set
to show the current date every time it appears using the following piece of code before the userform shows. UserForm1.Calendar1.Today This appears to work but I would value confirmation that this is how it is supposed to be done. Then I would ask how I could modify or add to it so that when someone starts entering a sequence of dates using the pop-up, that the first date highlighted is the current date as it is at the moment, but after that the date highlighted is the last date that the person selected, and not the current date? I hope that makes sense and if so I would be grateful for any help. Kind Regards, Graham Haughs Turriff, Scotland |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date formating, creating unique calender | Excel Worksheet Functions | |||
link a date in excel to calender | Excel Discussion (Misc queries) | |||
how do I set up in excel a calender to enter a date | Excel Discussion (Misc queries) | |||
Adding a date to calender to automatially generate another date? | Excel Worksheet Functions | |||
How do I copy a date from excel to a outlook calender? | Excel Discussion (Misc queries) |