DTPicker to be dropped down on initialisation

  • Thread starter Thread starter WhytheQ
  • Start date Start date
W

WhytheQ

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTPicker controls missing from userform 4
Set DTPickers Data to Todays Date by Default 1
Problems with MS-DateTime-Picker 6.0 2
Date & Time Picker Properties Question 19
DTPicker Resizing 2
Set DTPicker Date Value if it is not Visible on Userform 4
Date from DTPicker 3
DTPicker Default Date 0

Back
Top