In the next section, we’ll add a macro button that calls this procedure to the Quick Access Toolbar (QAT). Don’t add this procedure to the UserForm’s module.

You can run a Macro in Excel by clicking the macros command on the Developer tab, using a combination shortcut key, by clicking on a graphic object, etc.

Last month’s article, “ Pro tip: Add a UserForm to aid data entry in Excel,” shares the basics of creating an Excel UserForm using VBA to populate list controls.

So, individuals can create a link from the command button to a worksheet in your workbook. In this tutorial, we will explain how to use the Command button to navigate between worksheets in Excel.