Finance

Charts

Statistics

Macros

Search

Creating a UserForm or Custom Form, Excel VBA

The first step in creating a UserForm is to insert one into the Visual Basic Editor. To do this, press Alt + F11 to access the VBE and select your workbook’s name in the Project Explorer, as shown in the following figure.

Accessing the VBE Environment

With the workbook name selected, click on Insert / UserForm from the menu bar, as illustrated in the next figure.

Inserting a UserForm

A new UserForm opens in its design window, as shown in the following figure.

A New UserForm Opens

0 0 votes
Évaluation de l'article
S’abonner
Notification pour
guest
0 Commentaires
Le plus ancien
Le plus récent Le plus populaire
Online comments
Show all comments
Facebook
Twitter
LinkedIn
WhatsApp
Email
Print
0
We’d love to hear your thoughts — please leave a commentx