Calendar in UserForm

[cogent]

Hello

A while agao someone on this forum showed me how to add a clandar to a
UserForm for entering dates.

The solution was to add Calendar Control 10.0 to the Toolbox.

That calendar does not have, however, sufficient detail to select Day Date,
Month and Year. It allows selection only of Month, Year and Weekday. Am I
missing something?

W

 

[Dennis]

W,

Have you used the DTPicker1? This is included in the
MSCOMCT2.OCX file. To see a picture of the control go to:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/vbcon98/html/vbconusingdatetimepickercontrol.asp

If you do not have this OCX file you can download it from
MS. If you have the OCX file go to the VBE of Excel.
Select Tools|Additional Controls..., then select Microsoft
Date and Time Picker Control 6.0. This will add the
control to your tool box.

I hope this helps, Dennis

 

[cogent]

OK, i will try it.

Was I right that the Calendar Control 10.0 does not allow date selection?
That seems bizarre.

W

 

[cogent]

Yes, that looks really good. Thank you.

W

W,

Have you used the DTPicker1? This is included in the
MSCOMCT2.OCX file. To see a picture of the control go to:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/vbcon98/html/vbconusingdatetimepickercontrol.asp

If you do not have this OCX file you can download it from
MS. If you have the OCX file go to the VBE of Excel.
Select Tools|Additional Controls..., then select Microsoft
Date and Time Picker Control 6.0. This will add the
control to your tool box.

I hope this helps, Dennis

 

[Dennis]

You are welcome. Dennis

-----Original Message-----
Yes, that looks really good. Thank you.

W






.