ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PLEASEEEE HELP. DATE AND TIME PICKER CONTROL (https://www.excelbanter.com/excel-programming/421361-pleaseeee-help-date-time-picker-control.html)

K[_2_]

PLEASEEEE HELP. DATE AND TIME PICKER CONTROL
 
Hi all, Can please any body can help that how can i write a macro to
a button which can SetFocus to Date and Time Picker Control on sheet.
Like i want macro to select inside the date field of Date and Time
Picker Control when i click the button. I tried (see below the code)
but not working. Please help

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


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

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