Date and Time Picker

Guest

Posts: n/a

11th Dec 2008

Hi all, I have Date and Time Picker control on my Sheet and i also
have a Command Button on my Sheet. When i click on Date and Time
Picker control drop down arrow then a small calander appears from
which i can select the date. How can i do the same thing by clicking
the Command Button. In other words i want a macro in Command Button
that when i click the button it should show the calander from Date and
Time Picker drop down. I know it would be something like this (see
below). I am struggling to find the correct code line. Can please
someone help.

Private Sub CommandButton1_Click()
Me.DTPicker1.DropDown
End Sub

« Formula Problem in macro | Excel 2007 Programming Error - 0x80010105 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting current date on date/time picker control	=?Utf-8?B?RG91Z00=?=	Microsoft Access VBA Modules	1	19th Jul 2005 07:07 PM
I am trying to use the Microsoft Date and Time Picker control and I am getting the following error "an error occured in a call to the windows date and time picker control" in access 2000	Ralph Malph	Microsoft Access Forms	0	25th Oct 2004 07:00 PM
MS Date and Time Picker Control defaults to today's date	=?Utf-8?B?UmF2aQ==?=	Microsoft Outlook Form Programming	1	23rd Jan 2004 03:31 PM
MS Date and Time Picker Control defaults to today's date	=?Utf-8?B?UmF2aQ==?=	Microsoft Outlook VBA Programming	1	22nd Jan 2004 02:48 PM
MS Date and Time Picker Control defaults to today's date	=?Utf-8?B?UmF2aQ==?=	Microsoft Outlook Program Addins	0	14th Jan 2004 06:31 PM