Thread
:
DTPicker to be dropped down on initialisation
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary L Brown
external usenet poster
Posts: 219
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 With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown