Oceangirle
New Member
- Joined
- Mar 31, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hello,
This is my first time posting. I am a bit perplexed on how to structure my VBA code to get started, as dealing with a dynamic tab coding issue is new territory for me.
I have a workbook whose sheets are labeled as follows (mm-yy) so the first sheet will be labeled (04-21) and then each month it will be copied and placed before with the tab name being manually updated to the next month (I.e. 05-21 will be a copy of 04-21 with a different sheet name). Once this is done, I would like the VBA code to clear the check boxes on the new sheet, but leave the check boxes as is on the old sheet. Thus , 05-21 should have no boxes checked, but 04-21 should have the same boxes checked as before. Any advice would be helpful for how to begin with the tab issue?
This is my first time posting. I am a bit perplexed on how to structure my VBA code to get started, as dealing with a dynamic tab coding issue is new territory for me.
I have a workbook whose sheets are labeled as follows (mm-yy) so the first sheet will be labeled (04-21) and then each month it will be copied and placed before with the tab name being manually updated to the next month (I.e. 05-21 will be a copy of 04-21 with a different sheet name). Once this is done, I would like the VBA code to clear the check boxes on the new sheet, but leave the check boxes as is on the old sheet. Thus , 05-21 should have no boxes checked, but 04-21 should have the same boxes checked as before. Any advice would be helpful for how to begin with the tab issue?