Complicated matrix with buggy VBA. Don't know what went wrong, much less how to fix it :(
Hi! Hope this is acceptable here. I'm looking for someone to troubleshoot some VBAs. I think this is the right terminology? I work for a small county government. Part of my duties are to track and coordinate training for our elected officials. With 5 of them, plus myself, it can be a lot. I'm a visual person, so I created this matrix. I want it to do a few things when I eventually throw it up on a projector for them: show what they've taken to date, show what classes are most efficient to take, and demonstrate future changes by toggling a class on or off.
I'm pretty good with technology, but Excel is not in my wheelhouse. Full transparency, I ChatGPTed my way to this point. I told Chatty what I wanted this spreadsheet to do, and it walked me through the VBAs.
The top part works fine for the primary tracks. It's the crossover hours section that's faulty now. I want it to turn classes they've taken blue. Once they've satisfied that third crossover class for a specific track, I want it to essentially disqualify all the others by turning them purple.
For what it's worth, it was working like a gem (a bit slow, but working nonetheless) before I had to go back in and add some rows. Now it's a mess.
Is there anyone who can help me here? I was so proud of this baby, and it was actually a useful tool! I was so close to being able to use it with commissioners in a group setting. Now, I don't know even what to fix, much less how. I tried ChatGPT again, but no luck. I'm at the point I need a human! Happy to chat if you need more info or the file itself.
[link] [comments]
Want to read more?
Check out the full article on the original site