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.

Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another.

Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes.

Below we will look at a program in Excel VBA that creates an interactive Userform.

Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box.

Below we will look at a program in Excel VBA that creates a progress indicator.

The MultiSelect property in Excel VBA allows a user to select multiple items in a list box.

You can use a RefEdit control in Excel VBA to get a range from a user.

Below we will look at a program in Excel VBA which creates a Userform that contains multiple pages.