Calendar Control 12.0 help

[EAB1977]

When I am moving to a different month using the calendar control, I am
noticing that I must pick a date for my code to pick up the Month,
Year, and Day. Is there a way so when I switch to a different month, I
can programmatically(sp) set the date, to say, the first day of the
month that I selected?

 

[Bernie Deitrick]

At least for Calendar 11.0, there is no way that I know of to capture the
change of display month until the user selects a day on the new month's day
grid.

You could add the calendar control to a userform, and add buttons to change
the month and year and day as needed, but with just the calendar control,
you need to click a day after choosing the new month.

HTH,
Bernie
MS Excel MVP

 

[EAB1977]

Bernie,

I just changed from the Calendar Control 12.0 to the Monthview control.