Add date picker calendar to a user form

[pilgrimm]

I just came across an option in Excel to use a calendar to pick a date
for a cell. What I am now trying to do is to have a calendar come up
for 2 fields in a form. This way, to incert a date, you can choose it
from a calendar.

But, I am unsure how to add this to a User Form. On my user form I
have Name, id, and then the first field is called deduction date and
second date field is coverage date. Instead of typing in the date,
would like to have the date input from a pick list calendar.

Any help much appreciated.

Mel

 

[Nigel]

There is a calendar control.ocx available to do this. In the VB editor open
userform and right click in the ToolBox (controls area), select additional
controls and look for the "Calender control Vxx", version will depend on
your system. Check the box and it will be added to the ToolBox for use of
your userform

There are various properties you can set for this after you have added a
calendar control to your userform, the value of the calendar can be copied
to another control or worksheet.

Note: I believe in older versions of Excel the calendar control had to be
downloaded as it was not supplied as standard?

 

[Gord Dibben]

Nigel

Info only.

The calendar.ocx was included with editions of Office that included MS Access.

Otherwise it had to be downloaded.


Gord Dibben MS Excel MVP

 

[Nigel]

Thanks Gordon, I knew there was a reason why some installs had it, now I
know!

Cheers

--

Regards,
Nigel
(e-mail address removed)