Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar in UserForm
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar in UserForm
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 -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar in UserForm
OK, i will try it.
Was I right that the Calendar Control 10.0 does not allow date selection? That seems bizarre. W "Dennis" wrote in message ... 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 -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar in UserForm
Yes, that looks really good. Thank you.
W "Dennis" wrote in message ... 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 -----Original Message----- 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar in UserForm
You are welcome. Dennis
-----Original Message----- Yes, that looks really good. Thank you. W "Dennis" wrote in message ... 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 -----Original Message----- 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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter date in userform using Calendar Control | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
UserForm | Incorporate a calendar | Excel Programming | |||
How to use Microsoft Calendar Control 9.0 on a Userform | Excel Programming | |||
Calendar in UserForm | Excel Programming |