Date selector combobox

  • Thread starter Thread starter Steve P
  • Start date Start date
S

Steve P

Hello Excel gurus...

I am building a userform that will be used to drive a search engine for a
project I'm working on. I have two comboboxes on the form and want the two
comboboxes to be used to select a "start" date and a "end" date to select a
user specified date range. What is the best way to accomplish this?
 
If the dates that the user can choose are known, you could add the dates when
you load the userform:

Option Explicit
Private Sub Userform_Initialize()
dim myDate as date
for mydate = dateserial(2008,1,1) to dateserial(2008,2,12)
me.combobox1.additem format(mydate,"mmmm dd, yyyy")
next mydate
end sub

But if there are lots and lots of dates, this becomes a pain for the user to
find the correct date to choose.

You may want to consider using a calendar control.

Ron de Bruin has some notes:
http://www.rondebruin.nl/calendar.htm

Or even 3 different controls (day, month, year) for each date.
 
Back
Top