Commonly in your input form you might have validation on a drop-down field ensuring the user picks their selection from a pre-defined list. In this example we have named the range ‘ListRegions’ and set it across the cell range B4:B7 to ensure it includes all 4 regions. We’ve set the field up with Data Validation Read More …
Category: User forms
Cascading data validation based on named ranges
When you fill in an online form it is quite common that a choice of drop down options will be dependant on one of your previous answers. In this post we’ll look at how you can replicate that in Excel. In this example, a firm has 8 offices across 3 different countries. When you Read More …
Walkthrough guide to build an Excel user form
In this article we’re going to cover how to create a user input form step-by-step, with data inputted and automatically saved within the file along with a reporting dashboard. In this short space we can only really cover how to build a basic form, but all the important Visual Basic code, etc is included and hopefully Read More …