Date and time picker use in a userform

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.

[email protected]
 
M

muddan madhu

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
 
O

om

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
 
Top