How to Combo Box Calendar

[DG]

Can someone point me in the right direction to have a userform with a combo
box that has a dropdown calendar that the user can select the date?

I see many with putting the calendar in a spreadsheet but I want it on the
userform. For example: when the user opens the spreadsheet a userform will
open and he/she will select the dates among other things. From that I query
an SQL db and return the results to the spreadsheet. I didn't want to
clutter the spreadsheet with the dates.

Any help would be great.

Dan

 

[merjet]

In the VB Editor right-click on the Toolbox (containg the other
controls), then click Additional Controls, then check Calendar Control
10.0 (or whatever number is there).

Hth,
Merjet

 

[DG]

That's the ticket.

Learn something new everyday.

Thanks

 

[M. Authement]

Just a warning from personal experience...mscal.ocx is not a standard
control. It is supposed to be part of Access and/or Office Professional
versions, but my experience has bee that the Office Professional case is not
always true.