- Business and Employment»
- Learn Business Skills
Creating a UserForm in Microsoft Excel - Step 1 - Accessing the Visual Basic Editor
This is the the first Hub of the series: "Creating A Userform in Microsoft Excel". In this series we will walk through the steps of creating a simple address book that will be managed via a userform.
Excel is such a versatile tool. Not only is it great for crunching numbers, it can also be used as a simple database. However, entering large amounts of data can be cumbersome. Using a simple UserForm, coupled with some visual basic can alleviate the work-load. In this series of tutorials, I will walk you through the creation of a simple address book.
Because we will be using visual basic, we will need access to the Visual Basic Editor. This editor is where we will design our userform and write the code to go with it. So here is how you find it. First, make sure you can see the developer tab. If you can't find the Developer tab, follow the steps below.
- Click on the office button in the upper left-hand corner
- Choose "Excel Options" located in the bottom right-hand corner of the drop-down
- Choose "Popular" from the list on the left
- Within the screen that is displayed, check the "Show Developer tab in the Ribbon" check box
The Developer tab should now display on the ribbon to the right of "View" and to the left of "Add-Ins".
Once you are within the Developer tab, you can access the Visual Basic Editor by clicking "Visual Basic" on the far left. The following screen should display.