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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> That's the ticket.
>
> Learn something new everyday.
>
> Thanks
>
> "merjet" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>
>