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.

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.