Glen Alfaro
howto · 2025-03-11
How to Utilize Comments on VBA
This tutorial demonstrates how to create and manage comments in VBA effectively. Learn best practices for writing comments, debugging techniques, and strategies for managing comments in your VBA projects. Enhance your coding experience and improve collaboration with clear and concise comments in your code.
howto · 2025-03-11
How to Add Delay During Code Execution Using VBA
This article demonstrates how to add delay time during VBA code execution. Learn about various methods such as Sleep, Application.Wait, and loops with DoEvents to enhance your VBA applications. Discover practical examples and improve your coding skills with these essential techniques.
howto · 2024-02-02
How to Check if a String Contains a Substring in VBA
This tutorial demonstrates how to return a boolean if a string contains another string in VBA.
howto · 2024-02-02
How to Unlock VBA Password Using VBA Scripts
This tutorial demonstrates how to crack the password of a VBA script using VBA codes.
howto · 2024-02-02
How to Find the Last Row and Column in VBA
This tutorial demonstrates how to get the number of last used row and column in Excel VBA.
howto · 2024-02-02
How to Write Data to Text File Using Excel VBA
This tutorial demonstrates using VBA to generate text files.
howto · 2024-02-02
How to Sort the Elements of an Array and Arraylist in VBA
This tutorial demonstrates how to sort the elements of an array and arraylist in VBA.
howto · 2024-02-02
How to Find a Value in a Column Using Excel VBA
This tutorial demonstrates different ways to find a value in a column in VBA.
howto · 2024-02-02
How to Declare and Initialize String Array in VBA
This tutorial demonstrates how to declare and initialize string array in VBA.
howto · 2024-02-02
How to Create and Utilize a Dictionary in VBA
This tutorial demonstrates how to declare and utilize a Dictionary in VBA.
howto · 2024-02-02
How to Utilize Number Formats in Excel VBA
This tutorial demonstrates different ways in formatting numbers in Excel VBA.
howto · 2024-02-02
How to Get the Array Length in VBA
This tutorial demonstrates different ways to get the array length in VBA.
howto · 2024-02-02
How to Print Output in the Immediate Window in VBA
This tutorial will demonstrate how to print output of VBA codes in the immediate window in Excel VBA.
howto · 2024-02-02
How to Use Try-Catch in VBA
This tutorial will demonstrate how to implement try-catch method as error handling procedure in VBA.
howto · 2024-02-02
How to Use Excel VBA to Run SQL Query
This tutorial demonstrates running a SQL Query using Excel VBA.
howto · 2024-02-02
How to Check if a File Exists Using VBA
This tutorial demonstrats to check if a file exist in a folder using VBA.
howto · 2023-02-06
Loops and Exit Loops in VBA
This tutorial demonstrates how to Exit a For, Do Until, Do While Loop in VBA.
howto · 2022-04-18
The Use of Function in VBA
This tutorial demonstrates how to create and use a Function for object and non-object data types.