ExcelBanter - Calendar Text Box all the same

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calendar Text Box all the same (https://www.excelbanter.com/excel-worksheet-functions/250365-calendar-text-box-all-same.html)

Calendar Text Box all the same

How can I make each calendar day for a whole year have the same text in it
withough cut/paste each individual box seperately....Is there a way to format
the text box so they are all the same for the 12 months?

All times are GMT +1. The time now is 08:31 AM.