Prev: Reading properties from closed book
Next: Looping Open and Save as CSV
From: EAB1977 on 26 May 2010 11:34
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?
From: "Bernie Deitrick" deitbe on 26 May 2010 15:07
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" <koolaid4u(a)yahoo.com> wrote in message
news:4b9c4f50-f4bd-4801-be9d-40d53449e383(a)o1g2000vbe.googlegroups.com...
> 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?


From: EAB1977 on 27 May 2010 11:16
Bernie,

I just changed from the Calendar Control 12.0 to the Monthview control.
 | 
Pages: 1
Prev: Reading properties from closed book
Next: Looping Open and Save as CSV