UserForm | Incorporate a calendar
 

Hello

I am creating a Userform in which the user needs to specify a date. I
prefer to have a "point-and-click" calendar for all available dates. How
can I do that?

I think that the calendar is callable for a number of other Office programs
but I cannot figure it out for the Userform.

Thank you in advance.

W

UserForm | Incorporate a calendar
 

Assuming that you have the calendar control on your system, right-click on
the toolbox and select 'Additional Controls', select Calendar Control, and
then you can drag it onto your form.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cogent" wrote in message
...
Hello

I am creating a Userform in which the user needs to specify a date. I
prefer to have a "point-and-click" calendar for all available dates. How
can I do that?

I think that the calendar is callable for a number of other Office
programs
but I cannot figure it out for the Userform.

Thank you in advance.

W

UserForm | Incorporate a calendar
 

Cool!

W

"Bob Phillips" wrote in message
...
Assuming that you have the calendar control on your system, right-click on
the toolbox and select 'Additional Controls', select Calendar Control, and
then you can drag it onto your form.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cogent" wrote in message
...
Hello

I am creating a Userform in which the user needs to specify a date. I
prefer to have a "point-and-click" calendar for all available dates.
How
can I do that?

I think that the calendar is callable for a number of other Office
programs
but I cannot figure it out for the Userform.

Thank you in advance.

W

UserForm | Incorporate a calendar
 

I have a "sort of" calendar example on my website.
Date/Time Picker

It's not a click a day-of-month example, but allows you to click a month and
scroll it up and down (or any other portion of the date for that matter)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"cogent" wrote in message
...
Hello

I am creating a Userform in which the user needs to specify a date. I
prefer to have a "point-and-click" calendar for all available dates. How
can I do that?

I think that the calendar is callable for a number of other Office
programs
but I cannot figure it out for the Userform.

Thank you in advance.

W