So, what's this then?

These are the macro-enabled Excel workbooks I made to play D&D with my friends. They're kind of a lot - I've spent at least a few hundred hours on this project.
I tried to make them flexible enough to be able to accomodate at least the main classes in D&D 5e (I've used them for a number of characters). Feel free to try to use them - your mileage may vary, though.

Wait, Excel?

Yeah. If you didn't know, Excel, along with a lot of other MS Office products, supports scripting using "VBA", or Visual Basic for Applications.
It's seriously old-school. Like, just look at the IDE:

People have used VBA to do terrible, awful things over the years, and Microsoft seems to really regret its existence.

...and this is how you decided to program a character sheet?

Yeah, I suppose I have some explaining to do.

So, when my first character, Eryn, died, I decided to play a Wizard. Eryn was a Ranger, which I had specifically chosen for its accessibility since I was a new player.
As you can imagine, playing a Wizard was a little bit of a difficulty spike. I struggled in particular with keeping track of all my spells and what they did, so I eventually made a spreadsheet for them to augment my pdf character sheet. It looked something like this:

This worked for quite some time.
Eventually, though, I had to learn how to program in Visual Basic for my job (don't ask). Simultaneously, I acquired some more managerial, spreadsheet-oriented tasks. Naturally, I ended up combining these things to make some pretty excessive spreadsheets.

I felt like I had gained some dark, tabboo power. So, of course I used that power for D&D.

It started small at first - just some shortcuts to expend spell slots and determine what was available to cast. Then I got started making user forms, and it was all downhill from there.
I got a lot of satisfaction showing my group what was new in my spreadsheet each week and seeing the horror on their faces. I was making Excel do things for which it was never intended, things for which it should not be used. It was awesome.

Recently though I've lost steam. The project has about hit critical mass - you can only write spaghetti for so long. I still use my workbook, but I don't actively add anything anymore.

You monster. How do I use this?

Quite frankly, I don't have the spoons to make a tutorial. However, there is some documentation inside the workbooks themselves, so hopefully that's useful.
I've also provided the filled-out workbook I have for my character Vera - it's the third link. This snapshot was captured on 1/29/23.

In short, though, you'll mostly just want the workbook in the first link. It can hold all of your character sheet info. The workbook in the second link is full of monster statblocks and works with the "Monsters" sheet in the character sheet workbook. I use it for when I summon things.

If you end up actually using this and have questions, feel free to reach out to me. My contact info is on this page.