Practical solutions

VBA Howtos How-To Guides

Solve the problem. Keep building. Collection of VBA how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

VBA ArrayHow to Get the Array Length in VBAThis tutorial demonstrates different ways to get the array length in VBA. VBA DebuggingHow to Print Output in the Immediate Window in VBAThis tutorial will demonstrate how to print output of VBA codes in the immediate window in Excel VBA. VBA Try CatchHow to Use Try-Catch in VBAThis tutorial will demonstrate how to implement try-catch method as error handling procedure in VBA. VBA SQLHow to Use Excel VBA to Run SQL QueryThis tutorial demonstrates running a SQL Query using Excel VBA. VBA FileHow to Check if a File Exists Using VBAThis tutorial demonstrats to check if a file exist in a folder using VBA. VBA SortHow to Sort Data Range by Specific Column in Excel VBAThis tutorial demonstrates how to sort a data range by specific column in excel VBA. VBA CellHow to Set Formulas for a Cell in VBAThis tutorial demonstrates how to set and use cell formulas in VBA. VBA ExcelHow to Create New Excel Sheet in VBA This tutorial demonstrates how to create new Excel sheet in VBA . VBA StringHow to Convert String to Number in VBAThis tutorial demonstrates how to convert a string to a number in VBA. VBA ColumnHow to Count Columns in VBAThis tutorial demonstrates how to count columns in VBA. VBA FunctionHow to Add New Line in VBAWe will demonstrate how to go to next line in VBA. VBA WorkbookHow to Open a Workbook by Specifying Its Path in Microsoft Excel Using VBAThis article demonstrates how to use a command in VBA to open another workbook just by specifying its path. VBA ExcelHow to Copy and Paste Values in VBAThis article demonstrates how to copy the values of one column to another in the same sheet or a different sheet in Excel using VBA. VBA ExcelHow to Convert a Column Number to Letter in Excel Using VBAThis article describes different functions that convert a column number to a column letter in Microsoft Excel using VBA. VBA VLookupHow to Reference Another Sheet in VLookup Using VBAThis article explains how to reference another sheet in VLookup using VBA. VBA FileHow to Read a Text File Line by Line in VBAThis article describes how to parse through the entire file, line by line, in VBA. VBA JSONHow to Parse JSON With VBAThis article describes how to parse JSON without using external libraries in VBA. VBA WindowHow to Clear the Immediate Window Using VBAThis article describes how to clear the contents of the immediate window in Microsoft applications using VBA. VBA RegexHow to Use Regular Expressions in Excel VBAThis article describes how to create and match strings based on a regular expression in Microsoft Excel using VBA. VBA SaveHow to Save as in Microsoft Excel VBAThis article explains the usage of the Save As function in Microsoft Excel VBA. VBA FileHow to Loop Through Files in a Folder Using VBAThis article describes how to loop through the files that are stored in a folder using VBA. VBA CSVHow to Import CSV Into Access using VBAThis article describes the method to import CSV into Access VBA. VBA Progress BarHow to Create a Progress Bar in Excel VBAThis article describes how to create a progress bar in Microsoft Excel using VBA. VBA IntegerHow to Convert Integer to String Data Type in Microsoft Excel VBAThis article explains the ways to convert an integer data type to string in Microsoft Excel VBA.