Date and time picker use in a userform
 

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.


--
Ed Ayers

Date and time picker use in a userform
 

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


On Nov 15, 10:08*am, ed.ayers315
wrote:
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. *


--
Ed Ayers

Date and time picker use in a userform
 

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

"muddan madhu" wrote:

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


On Nov 15, 10:08 am, ed.ayers315
wrote:
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.


--
Ed Ayers

.