Hi All,
I'm trying to make a calendar that starts from a month selected from a drop down list and then populates the correct months and dates into the calendar. It has to show the 12 months from the month selected, so it will usually roll over years (i.e. dec 2020 to jan 2021).
So far I have tables in the DATA sheet for the drop down lists in cells F1, N1, X1 and V3 although I don't think I have the cells in the tables formatted correctly, at the moment the Months table has the "custom formatting" of mmmm (for the full month name).
Cell B5 (year) is populated from cell F1
Cell B9 (first month) is populated from cell N1
The combination of B5 and B9 should then determine what dates are entered into the months (e.g 1st Month = September, Year = 2020, cell C11 starts at 1st, D11 is 2nd, E11 is 3rd etc etc)
I also then have:
1. a field in cell F3 in which to enter an MOT date which should apply conditional formatting to that date.
2. a field in cell N3 to enter a service date, which should apply conditional formatting to that date and then every other date going forward determined by the frequency in months from the drop down selection in cell V3.
3. a field in cell V1 to enter an inspection date, which should apply conditional formatting to that date and every date going forward determined by the frequency in weeks from the drop down selection in cell X1.
I'm assuming some or all of this is going to have to be achieved with VBA and I'm fairly comfortable entering VBA in the editor, but I'm new to VBA and don't quite know where to start.
If anyone could help bit by bit with this or point me in the right direction, I'd be massively grateful..
Work in progress sheet attached.
Thanks in advance
Bookmarks