VBA

How-tos How to Set Worksheets in VBA This tutorial provides a comprehensive guide on how to set worksheets in VBA. Learn to activate worksheets, set worksheet variables, loop through multiple sheets, and reference … ↗ How-tos How to Delete a Row in VBA This tutorial demonstrates how to delete a row in VBA. ↗ How-tos Global Variable in VBA This tutorial demonstrates how to create global variables in VBA. ↗ How-tos How to Delete File in VBA This tutorial demonstrates how to delete file in VBA. ↗ How-tos Out of Memory in VBA This tutorial demonstrates what is out of memory error in VBA. ↗ How-tos Selection of Cells in VBA This tutorial demonstrates how the selection of cells in VBA works. ↗ How-tos How to Compare Strings in VBA We will demonstrate how to compare strings in VBA. ↗ How-tos Array List in VBA We will demonstrate how to use array lists in VBA. ↗ How-tos How to Create an Array From a Specific Range in Excel Using VBA This article illustrates how to create an array using a specific range in Microsoft Excel using VBA. ↗ How-tos Project Password in Microsoft Excel VBA This article explains the usage of a project password in Microsoft Excel VBA. ↗ How-tos On Error Statement in Microsoft Excel VBA This article explains the usage of the On Error statement in Microsoft Excel VBA. ↗ How-tos MsgBox in Microsoft Excel VBA This article explains the usage of MsgBox in Microsoft Excel VBA. ↗ How-tos How to Check if a Cell Is Empty in Microsoft Excel VBA This article explains the ways to check if a cell is empty in Microsoft Excel VBA. ↗ How-tos How to Unsort Sorted Data in Microsoft Excel VBA This article explains the ways to unsort sorted data in Microsoft Excel VBA. ↗ How-tos How to Convert Text to Number in Microsoft Excel VBA This article explains the ways to convert textual data to numbers in Microsoft Excel VBA. ↗ How-tos 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. ↗ How-tos How to Unlock VBA Password Using VBA Scripts This tutorial demonstrates how to crack the password of a VBA script using VBA codes. ↗ How-tos 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. ↗ How-tos How to Write Data to Text File Using Excel VBA This tutorial demonstrates using VBA to generate text files. ↗ How-tos 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. ↗ How-tos 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. ↗ How-tos How to Declare and Initialize String Array in VBA This tutorial demonstrates how to declare and initialize string array in VBA. ↗ How-tos How to Create and Utilize a Dictionary in VBA This tutorial demonstrates how to declare and utilize a Dictionary in VBA. ↗ How-tos How to Utilize Number Formats in Excel VBA This tutorial demonstrates different ways in formatting numbers in Excel VBA. ↗