How to run a SQL query in Excel VBA
In this Excel VBA tutorial lesson, you will see how to Run the SQL statements in Excel.
Best Excel Tutorial
The largest Excel knowledge base ✅ The best place to learn Excel online ❤️
Regular Expression in Excel Vba
In this article we will learn to use Regex in Excel.
How to Create New Worksheet in Excel Vba
One of the things that VBA can be used to do is to create new worksheets. In this article, you learn how to create a new worksheet in Excel using VBA.
How to Loop Through Rows and Columns in a Range
In this article we will learn how to use Excel macros to loop through a range with different techniques. Lets start with how to create an Excel module and Subroutine to write the code.
How to Manipulate Strings in Excel Vba
In this article, we will learn to do string operations using Excel VBA. String can be any text or a combination of text and numbers etc.
How to Write to a Cell in Excel Vba
In this Excel tutorial lesson, I will guide you through the basics of Excel VBA and how you can use Excel VBA to write to a cell in an Excel sheet.
Vba Code to Create Folder and Subfolders
In this Excel VBA tutorial lesson, you learn how to create folders and subfolders using Excel VBA.
While Wend Loop in Excel Vba
In this Excel Vba tutorial article, I will explain how to use the While Wend loop in Excel VBA Code.
How to Add Hours to Time in Excel Vba
In this article, we will learn to add hours to time together in Excel VBA.
In Excel VBA, you can add hours to a date and time value using the DateAdd function. The DateAdd function allows you to perform various time arithmetic operations, including adding hours.
How to disable close button userform?
In this Excel VBA tutorial lesson, I will show you how to disable the close button in an Excel userform. Let us first look at the close button we use in Excel userforms: