ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control help (https://www.excelbanter.com/excel-programming/306269-calendar-control-help.html)

Richard Buttrey

Calendar Control help
 
Can anyone offer some guidance on the use of the Calendar object in
Excel?

Basic stuff like opening and dismissing it under VBA control, and
accessing and using its various properties.

In particular capturing the date selected from the calendar and using
it elsewhere in VBA.

I've been experimenting and tried the MS office help but it doesn't
appear to tell me what I want.

Usual TIA.

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Tom Ogilvy

Calendar Control help
 
See Ron de Bruin's site:

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

--
Regards,
Tom Ogilvy

"Richard Buttrey" wrote in
message ...
Can anyone offer some guidance on the use of the Calendar object in
Excel?

Basic stuff like opening and dismissing it under VBA control, and
accessing and using its various properties.

In particular capturing the date selected from the calendar and using
it elsewhere in VBA.

I've been experimenting and tried the MS office help but it doesn't
appear to tell me what I want.

Usual TIA.

Rgds


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________





All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com