Date and time picker use in a userform

  • Thread starter Thread starter ed.ayers315
  • Start date Start date
E

ed.ayers315

Hello,

New to this forum. What I see I like and feel I will get a solution here.

I have a user form designed where I need the user to put 38 Dates and times
of when events happen. It is easy to just expect them to manually put in the
data but we all know the more typing the less chace of getting the info you
need.

Does an answer exist for this issue?

I can send the file but do not see a way to attach here.

(e-mail address removed)
 
To Display date in combobox, you can use this

Private Sub UserForm_Initialize()

For dt = 40000 To 40500
With UserForm1
.ComboBox1.AddItem (Format(dt, "MMM DD,YYYY"))
End With
Next dt
End Sub
 
you can also use date and time picker control to pick date

For this right click on toobox in VBA window.
go to additional controls - Select Microsoft Date and Time Picker Control
6.0 and place it on your user form..

Regards
Om
 
Back
Top