Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi and a Happy New Year to you!
I have this message box code
I'd be grateful for some code that will automatically advance the cell references each year, so Jan 1 2023 shows
and so on at the start of each year.
Many thanks!
I have this message box code
VBA Code:
MsgBox "Monthly Tracking VBA: Change cell from AN1 to AO1 for " & Year(Now()), vbInformation, "New Year Update 2 of 2"
I'd be grateful for some code that will automatically advance the cell references each year, so Jan 1 2023 shows
VBA Code:
"Monthly Tracking VBA: Change cell from AO1 to AP1 for " & Year(Now()), vbInformation, "New Year Update 2 of 2"
Many thanks!