I have 12 wide sheets each containing 6 text boxes at intervals along the top with the date in, in "February 2005" format.
Every year, I have to alter the year as well as the headings. The cells are easy, but how do I access each text box to alter the contents of the text box from "2005" to "2006" within code so as to save loads of time?
I tried SelectAll and played with some Shapes and Shape Range ideas but the text boxes seem to be named quite eratically and it seems impossible to write anything that works. I am using Excel 2000 and Visual Basic 6.
Thanks
Paula
Every year, I have to alter the year as well as the headings. The cells are easy, but how do I access each text box to alter the contents of the text box from "2005" to "2006" within code so as to save loads of time?
I tried SelectAll and played with some Shapes and Shape Range ideas but the text boxes seem to be named quite eratically and it seems impossible to write anything that works. I am using Excel 2000 and Visual Basic 6.
Thanks
Paula