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

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?


--

Regards,
Nigel
(E-Mail Removed)



<(E-Mail Removed)> wrote in message
news:4ebd898e-fbda-4111-b6b8-(E-Mail Removed)...
>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

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

On Tue, 19 Feb 2008 11:12:59 -0000, "Nigel" <nigel-(E-Mail Removed)> wrote:

>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?

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

Cheers

--

Regards,
Nigel
(E-Mail Removed)



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> 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
>
> On Tue, 19 Feb 2008 11:12:59 -0000, "Nigel" <nigel-(E-Mail Removed)>
> wrote:
>
>>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?
>