Basics of VBA / Macros Chapter – 87 (Userform Part-8)
Loop through Controls With just a few lines of code, we can easily loop through controls on an Excel VBA Userform. The Userform we are going to…
Read article →Category Archives: Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Basics of VBA / Macros Chapter – 86 (Userform Part-7)
Basics of VBA / Macros Chapter – 86 (Userform Part-7)
Dependent Combo Boxes Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes. The Userform we are going…
Read article →Basics of VBA / Macros Chapter – 85 (Userform Part-6)
Basics of VBA / Macros Chapter – 85 (Userform Part-6)
Multicolumn Combo Box Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box. The Userform we are…
Read article →Basics of VBA / Macros Chapter – 84 (Userform Part-5)
Basics of VBA / Macros Chapter – 84 (Userform Part-5)
Multiple List Box Selections The MultiSelect property in Excel VBA allows a user to select multiple items in a list box. The Userform we are going to create…
Read article →Basics of VBA / Macros Chapter – 83 (Userform Part-4)
Basics of VBA / Macros Chapter – 83 (Userform Part-4)
Progress Indicator 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…
Read article →Basics of VBA / Macros Chapter – 82 (Userform Part-3)
Basics of VBA / Macros Chapter – 82 (Userform Part-3)
Currency Converter 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…
Read article →Basics of VBA / Macros Chapter – 81 (Userform Part-2)
Basics of VBA / Macros Chapter – 81 (Userform Part-2)
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…
Read article →Basics of VBA / Macros Chapter – 80 (Userform Part-1)
Basics of VBA / Macros Chapter – 80 (Userform Part-1)
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…
Read article →Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
Loan Calculator 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…
Read article →Basics of VBA / Macros Chapter – 78 (ActiveX Controls Part-7)
Basics of VBA / Macros Chapter – 78 (ActiveX Controls Part-7)
Spin Button 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.…
Read article →Basics of VBA / Macros Chapter – 77 (ActiveX Controls Part-6)
Basics of VBA / Macros Chapter – 77 (ActiveX Controls Part-6)
Option Buttons If you have more than one option button, only one of the option buttons can be selected. To create option buttonsin Excel VBA, execute…
Read article →Basics of VBA / Macros Chapter – 76 (ActiveX Controls Part-5)
Basics of VBA / Macros Chapter – 76 (ActiveX Controls Part-5)
Check Box 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.…
Read article →