A User Form is a custom-built dialog box that makes a user data entry more controllable and easier to use for the user. In this chapter, you will learn to design a simple form and add data into excel.
- Step 1 − Navigate to VBA Window by pressing Alt+F11 Navigate to the “Insert” Menu and select “User Form”.
- Step 2 − Design the forms using the given controls.
- Step 3 − After adding each control, the controls have to be named.
- Step 5 − Add the code for the form load event by performing a right-clicking on the form and selecting ‘View Code’.
- Step 6 − Select ‘Userform’ from the objects drop-down and select the ‘Initialize’ method as shown in the following screenshot.
- Step 7 − Upon Loading the form, ensure that the text boxes are cleared, drop-down boxes are filled and Radio buttons are reset.