View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default 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