Using date Pickers to highlight range of cells...

Hi,

I’ve used excel for basic spreadsheets for years but only recently moved on to VBA. I’ve been fine so far but if got an idea for a sheet I need to create but I can’t see how to do it. Or if there is a better way?

I have a table which is basically a calendar of the 2019/2020 year. The months of year are down along the number side and the days in the month running along horizontally with the letters.

I want the user to input a from and to date which will then change the colour of those cells in the calendar table.

I have months in column A and days (1-31) in row 1.

I have a command button which links to a Userform where there is a Date From date picker and Date To date picker. I can’t figure out how to process that information and mark the cells equivalent to those dates in my table.???

Any hints greatly appreciated.

The code within the attached may be a starting point.
The calendar is progressive (i.e. select a start date, this establishes the range, start date within 2019 will give range 2019/2020 etc.,)
torachan.

Thanks. I’ll take a look.