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 âCategory Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
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 âBasics of VBA / Macros Chapter â 75 (ActiveX Controls Part-4)
Basics of VBA / Macros Chapter â 75 (ActiveX Controls Part-4)
Combo 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âŚ
Read article âBasics of VBA / Macros Chapter â 74 (ActiveX Controls Part-3)
Basics of VBA / Macros Chapter â 74 (ActiveX Controls Part-3)
List Box 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âŚ
Read article âBasics of VBA / Macros Chapter â 73 (ActiveX Controls Part-2)
Basics of VBA / Macros Chapter â 73 (ActiveX Controls Part-2)
Text Box A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA,âŚ
Read article âBasics of VBA / Macros Chapter â 72 (ActiveX Controls Part-1)
Basics of VBA / Macros Chapter â 72 (ActiveX Controls Part-1)
ActiveX Controls Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc. To create an ActiveX control in Excel VBA, execute theâŚ
Read article âBasics of VBA / Macros Chapter â 71 (Application Object Part-4)
Basics of VBA / Macros Chapter â 71 (Application Object Part-4)
Write Data to Text File Below we will look at a program in Excel VBA that writes an Excel range to a CSV (comma-separated-value) text file. PlaceâŚ
Read article âBasics of VBA / Macros Chapter â 70 (Application Object Part-3)
Basics of VBA / Macros Chapter â 70 (Application Object Part-3)
Read Data from Text File Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographicalâŚ
Read article âBasics of VBA / Macros Chapter â 69 (Application Object Part-2)
Basics of VBA / Macros Chapter â 69 (Application Object Part-2)
StatusBar The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way, you can let theâŚ
Read article â