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.