View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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