Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date and Time Picker
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pop up Date time picker | Excel Discussion (Misc queries) | |||
Date Time Picker | Excel Discussion (Misc queries) | |||
Date and Time Picker | Excel Discussion (Misc queries) | |||
date time picker | Excel Programming | |||
Set Value for Date/Time Picker | Excel Programming |