use of calendar object?
 

Hi,
In vb there is a calendar object that can be added to applications, where
one month is displayed and the user can click either the left or right arrow
to go to another month. Can something similar be done in excel?

I have an excel application that the front end is a form, the user can get
summary data in a pivot table, by entering start dates and end dates in a
dialog box which then get saved in a variable. I would like to give the user
the option of clicking on a button in the dialog box, which will display a
calendar, where the user can select a date instead of typing it in box. Can
this be done?

CathyZ

use of calendar object?
 

Yes,

http://www.rondebruin.nl/calendar.htm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"CathyZ" wrote in message
...
Hi,
In vb there is a calendar object that can be added to applications, where
one month is displayed and the user can click either the left or right
arrow
to go to another month. Can something similar be done in excel?

I have an excel application that the front end is a form, the user can get
summary data in a pivot table, by entering start dates and end dates in a
dialog box which then get saved in a variable. I would like to give the
user
the option of clicking on a button in the dialog box, which will display a
calendar, where the user can select a date instead of typing it in box.
Can
this be done?

CathyZ