K
K
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
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