How to create my user form in Excel (example)

Who I am
Catherine Le Nevez

Author and references

Forms greatly simplify your work in Excel. It allows you to create applications very efficient and intuitive within the Office environment . In addition to speeding up processes and avoiding errors when entering data and performing calculations. Creating your UserForm in Excel is an easy task.

Forms have controls that make creating forms as simple as a simple PowerPoint presentation. Controls should just drag it onto forms and tell them to perform certain actions . But the first thing you need to do is create a new UserForm.

How to Create My User Form in Excel - Very Easy

How to create my UserForm?

To be able to create your first form in Excel from header to VBA editor. Click the Developer tab and select the Visual Basic option or use the shortcut command Alt + F11 .

The VBA editor window opens, to add a new module click on the menu Enter and then on UserForm . Automatically, when the new module is created, it appears in a container folder with the default name. There you have to host all the files you need, as well as the new modules related to that project you just created.

A floating box with a group of controls also appears. Those controls you can add in UserForm. Both the added objects and the UserForm have their own properties, methods, and events where you can change the appearance and behavior.

The properties box appears just below the box where the containing folder is located. Otherwise, press F4. The box contains the properties on the right side and the property name on the left side.

Read How to use or link my Google or Gmail account on two or more Android phones or iPhones at the same time

Set initial properties

With the form created, it is necessary change the initial properties . Change the name of the module, choose the background colors, choose the font and also what its position will be.

You can do it in design mode or by code , where you edit the properties by entering the object name, followed by a period, the property name, an equal sign =, and the property value.

UserForm controls

The Toolbox or UserForm controls are the toolbar that you can add to the form by clicking and dragging objects within UserForm at the desired location.

  • Label: used to insert text that serves as a reference for the end user. It is generally used to identify other controls.
  • TextBox: used for allow the user to enter data to perform an operation or to store. The entered text can be edited.
  • CommandButton(Button): as its name indicates, it is a button and is used to start a specific process or action.
  • ComboBox (combo box): this control is used to view multiple items in a list, but the end user can only choose one.
  • ListBox: a control used to add multiple items to a list so that the end user can choose one or more.
  • OptionButton: used to create multiple options where the end user can only select one.
  • CheckBox (checkboxes): control used to validate boolean information, i.e. it is possible to have only one answer between true and false.
  • Image: used to add images to the form.
  • Frame: this type of control is used to organize the controls within the form. Commonly used to group buttons, but you can also control the appearance of the controls it contains, such as the font.
  • MultiPage (multiple pages): this control adds multiple pages to a form. In turn, each form can contain a group of controls.
  • ScrollBar: allows fast scrolling of a list of items.
  • SpinButton (spin button): this is a two-arrow control that allows the end user to select a value by clicking the arrows.
Read How to upload WhatsApp status: the best WhatsApp status (example)
add a comment of How to create my user form in Excel (example)
Comment sent successfully! We will review it in the next few hours.