This repository is a collection of my VBA projects and their related posts. VBA-Macro-Projects automated processes, UserForm, Windows Application Programming Interface(API). VBA (Visual Basic for ...

This repository is a collection of my VBA projects and their related posts. VBA-Macro-Projects automated processes, UserForm, Windows Application Programming Interface(API). VBA (Visual Basic for ...

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

Excel is a useful program for creating tables, graphs and making complicated calculations automatically. It might seem complicated at the beginning, but when you get to know Excel's features, the ...