![]() |
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