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 Removed)
--
Ed Ayers

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
<edayers...@discussions.microsoft.com> 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...@hotmail.com
> --
> Ed Ayers

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
> <edayers...@discussions.microsoft.com> 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...@hotmail.com
> > --
> > Ed Ayers
>
> .
>