|
|
Search
Contextures Sites
|
||
|
|
|
|||
|
|
|
|
|
Search Contextures Sites
Excel Tutorial Videos 05
- Create a UserForm in Excel -- Part 1 of 3
- Create a UserForm in Excel -- Part 2 of 3
- Create a UserForm in Excel -- Part 3 of 3
- Excel UserForm ComboBox Code
Create a UserForm in Excel -- Part 1 of 3
To make it easier for users to enter data in a workbook, you can create an Excel UserForm. This is created in the Excel Visual Basic Editor (VBE). You can add text boxes, labels, combo boxes, buttons, and other features.
In this Excel video tutorial, a parts inventory is stored on a hidden worksheet. Users enter data by opening the UserForm, filling in the boxes, and clicking a button.
In part 1 of 3, you'll see how to create a blank Excel Userform. Then you'll name the Excel UserForm, and next you'll add text boxes and labels.
Users will be able to type data into the text boxes. Labels are added beside the text boxes, to describe what users should enter into the text box.
For written instructions for this Excel tutorial, see: Create a UserForm
Create a UserForm in Excel -- Part 2 of 3
In this Excel video tutorial, a parts inventory is stored on a hidden worksheet. Users enter data by opening the UserForm, filling in the boxes, and clicking a button.
In this video, which is Part 2 of 3, you'll learn how to add buttons and a title on the Excel UserForm.
With buttons on the Excel UserForm, a user can click to make something happen. For example, click a button after entering data in the text boxes, when you're ready to move the data to the worksheet storage area.
For written instructions for this Excel tutorial, see: Create a UserForm
Create a UserForm in Excel -- Part 3 of 3
In this Excel video tutorial, a parts inventory is stored on a hidden worksheet. Users enter data by opening the UserForm, filling in the boxes, and clicking a button.
In this video, which is Part 3 of 3, you'll learn how to add Excel VBA code to the controls, and you'll see how to test the Excel UserForm.
The Excel VBA code runs when a specific event occurs, such as clicking a button, or entering a combo box. In this example, the user will click a button, and the Excel VBA code will move the data to the worksheet storage area.
For written instructions for this Excel tutorial, see: Create a UserForm
Excel UserForm ComboBox Code
In this video, you'll see the code that fills the items in the combo boxes on the Excel UserForm that was created in this tutorial: Create a UserForm
The written explanation of the code can be found here: Excel VBA ComboBox Lists
Contextures Inc., Copyright ©2010
All rights reserved.
Last updated: April 25, 2010 11:49 AM
