Userform

A collection of 9 posts

How To Use VBA Controls Collection In Excel

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
24 October 2020

How To Use VBA Currency Converter In Excel

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:
23 October 2020

How To Use Interactive Userform In Excel

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
21 October 2020

How To Create Progress Indicator In Excel

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?
18 October 2020

Excel VBA : Userform and Ranges

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
16 October 2020