Lightweight Excel DND Character Sheet

Last year, after starting an online Dungeons and Dragons 5th Edition campaign with friends to get through the lockdown, I made an Excel Character Sheet so that my players could keep track of their in-game character stats and items. Please feel free to use this and share as required: dnd-character-sheetDownload

HOW TO… Excel: Create a hierarchical series of drop down boxes

As a result of prodding around the excel subreddit I found a query from user innocuous_gorilla about creating drop downs that are dependent upon each other. Due to working at NHS England where we have a massive array of organisation types and hierarchies, I quickly learnt how to do this! For example, in NHS England … Continue reading HOW TO… Excel: Create a hierarchical series of drop down boxes

HOW TO… VBA: Compare VBA Combo Box Values with Their Lists

Preamble So, a recent issue I’ve had using VBA to create UserForms to handle data input is data validation. Throughout my UserForm I’ve included a variety of Combo Boxes that contain lists of information the user can select. In most instances I would like the user to have inputted exactly one of the options within … Continue reading HOW TO… VBA: Compare VBA Combo Box Values with Their Lists

HOW TO… Excel: Create a Dynamic Data Range for a Chart

Continuing the theme of automatically updating charts, we’re going to look at how to make a chart deal with a dynamically changing data range. This is useful for situations where you have multiple measures that each have a different number of independent variables (the variables plotted on our x-axis, which was the month of the … Continue reading HOW TO… Excel: Create a Dynamic Data Range for a Chart