Word files are called documents. Whenever you start a new project in Word, you’ll need to create a new document, which can either be blank or from a template. You’ll also need to know how to open an existing document. Watch the video below to learn more about creating and opening documents in Word. To […]
Many of the features in Office are geared toward saving and sharing files online. OneDrive is Microsoft’s online storage space that you can use to save, edit, and share your documents and other files. You can access OneDrive from your computer, smartphone, or any of the devices you use. To get started with OneDrive, all […]
Introduction to MS Word Microsoft Word 2016 is a word processing application that allows you to create a variety of documents, including letters, resumes, and more. In this lesson, you’ll learn how to navigate the Word interface and become familiar with some of its most important features, such as the Ribbon, Quick Access Toolbar, and […]
Below we will look at a program in Excel VBA that creates an interactive Userform. The Userform we are going to create looks as follows: Explanation: whenever you enter a value in the ID text box, Excel VBA loads the corresponding record. When you click the Edit / Add button, Excel VBA edits the record […]
Below we will look at a program in Excel VBA which creates a Userform that contains multiple pages. This userform also contains images. The Multipage Control contains two pages. At page 1, the user can fill in his/her personal information. At page 2, the user can indicate which painting he/she likes the most. To create […]
When creating Userforms in Excel VBA, you can use the Controls collection to easily loop through controls and set a property of each control to a specific value. The Userform we are going to create looks as follows: To create this Userform, execute the following steps: 1. Open the Visual Basic Editor. If the Project […]
With just a few lines of code, we can easily loop through controls on an Excel VBA Userform. The Userform we are going to create looks as follows: To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. If the Project Explorer is not visible, click View, Project Explorer. 2. Click […]
Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes. The Userform we are going to create looks as follows: The user selects Animals from a drop-down list. As a result, the user can select an animal from a second drop-down list. The user selects Sports […]
Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box. The Userform we are going to create looks as follows: To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. If the Project Explorer is not visible, click View, Project Explorer. […]
The MultiSelect property in Excel VBA allows a user to select multiple items in a list box. The Userform we are going to create looks as follows: To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. If the Project Explorer is not visible, click View, Project Explorer. 2. Click Insert, […]
Below we will look at a program in Excel VBA that creates a progress indicator. We’ve kept the progress indicator as simple as possible, yet it looks professional. Are you ready? The Userform we are going to create looks as follows: To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. […]
Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another. The Userform we are going to create looks as follows: To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. If the Project Explorer is not visible, click […]
You can use a RefEdit control in Excel VBA to get a range from a user. The Userform we are going to create colors the minimum value of the range stored in the RefEdit control. To create this Userform, execute the following steps. 1. Open the Visual Basic Editor. If the Project Explorer is not […]
Add the Controls | Show the Userform | Assign the Macros | Test the Userform This chapter teaches you how to create an Excel VBA Userform. The Userform we are going to create looks as follows: Add the Controls To add the controls to the Userform, execute the following steps. 1. Open the Visual Basic […]
This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font types, insert rows and columns, add […]
A spin button can be used to increment a number in a cell. To create a spin button in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Spin Button. 3. Drag a spin button on your worksheet. 4. Right click the spin button […]
If you have more than one option button, only one of the option buttons can be selected. To create option buttons in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Option Button. 3. Drag two option buttons on your worksheet. 4. Right click […]
A check box is a field which can be checked to store information. To create a check box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Check Box. 3. Drag a check box on your worksheet. 4. Right click the check box […]
A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Combo Box. 3. Drag a combo box on […]
A list box is a list from where a user can select an item. To create a list box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click List Box. 3. Drag a list box on your worksheet. Note: you can change the […]
