Inquiry Update 2: Moving to Automation with VBA

Once the formulas were working, I wanted the sheet to do more than just sit there. I wanted it to act. This required VBA, which stands for Visual Basic for Applications. It is the programming language built into Excel.

I used AI to write a script for a “NEXT MONTH” button. When clicked, the button clears all the checkboxes for the current month and archives the final “Monthly Avg” into a separate summary tab. Writing this manually would have taken me weeks of study. With AI, I was able to explain the desired behaviour and get the code back in seconds.

The process of implementing the code involved opening the Developer tab and creating a Module. I learned how to troubleshoot “Debug” errors by feeding the error codes back into the AI. The software is now automated. It no longer requires manual cleanup at the end of the month, which removes the friction of starting a new tracking cycle.