Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker to be dropped down on initialisation
Hopefully an easy one for someone !?
I've got a userform with a DTpicker on it. When the userform initialises I want the dropdown calender on the date picker to be showing - i can't seem to find a method to do this. Is it possible, or should I switch to a different control? (i'm using XL2003) Any help greatly appreciated, Jason. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker to be dropped down on initialisation
If you want something that starts and stays visible, try 'Calendar Control'.
manipulate it like... Calendar.value = Now() 'brings you to today ActiveCell.value = Calendar.value 'puts the currently selected date on the calendar onto your worksheet Calendar.value = ActiveCell.value 'makes calendar to to date that is in current cell of your worksheet HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "WhytheQ" wrote: Hopefully an easy one for someone !? I've got a userform with a DTpicker on it. When the userform initialises I want the dropdown calender on the date picker to be showing - i can't seem to find a method to do this. Is it possible, or should I switch to a different control? (i'm using XL2003) Any help greatly appreciated, Jason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Size bug with DTPicker | Excel Programming | |||
can you use the dtpicker in an userfrom | Excel Worksheet Functions | |||
dtpicker problem | Excel Discussion (Misc queries) | |||
How to avoid re-initialisation when Unloading form | Excel Programming | |||
DTpicker problem | Excel Programming |