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.

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.