VBA is joyless. I started my career as VBA dev. It was the shitiest job I've ever had and worst job I can imagine to do. Bloated unreliable with disgusting API (like try catching for contains method on collection).
I had a job in university that involved picking up 20-foot-long sections of freshly sawn lumber (some of which weighed well over a hundred pounds) off of a moving set of chains and placing them in bins. That's it, for a 10 hour shift.
VBA sucks, but come on, there are worse jobs out there.
My first job (at 14) was a dishwasher. Not as bad as yours by the sound of it, but it was filthy and disgusting and I got paid $3.35 per hour.
Having that job put all my programming jobs in perspective. To preserve that I have a picture of a dude in a coal mine by my phone at work. Any time I'm asked to submit a pointless form, I think of that guy. I don't do this to shame myself but rather to put my work problems into perspective which helps me.