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

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

That's the ticket.

Learn something new everyday.

Thanks

"merjet" wrote in message
ups.com...
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

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.


"DG" wrote in message
...
That's the ticket.

Learn something new everyday.

Thanks

"merjet" wrote in message
ups.com...
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