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?

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" <(E-Mail Removed)> wrote in message
news:4b9c4f50-f4bd-4801-be9d-(E-Mail Removed)...
> 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,

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