ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date and Time Picker (https://www.excelbanter.com/excel-programming/421185-date-time-picker.html)

K[_2_]

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


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com