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 WorksheetHow to Set Worksheets in VBAThis 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 worksheets by index. Improve your Excel automation skills with practical examples and clear explanations. Perfect for beginners and experienced users alike. VBA RowHow to Delete a Row in VBAThis tutorial demonstrates how to delete a row in VBA. VBA VariableGlobal Variable in VBAThis tutorial demonstrates how to create global variables in VBA. VBA FileHow to Delete File in VBAThis tutorial demonstrates how to delete file in VBA. VBA MemoryOut of Memory in VBAThis tutorial demonstrates what is out of memory error in VBA. VBA SelectionSelection of Cells in VBAThis tutorial demonstrates how the selection of cells in VBA works. VBA StringHow to Compare Strings in VBAWe will demonstrate how to compare strings in VBA. VBA ListArray List in VBAWe will demonstrate how to use array lists in VBA. VBA ArrayHow to Create an Array From a Specific Range in Excel Using VBAThis article illustrates how to create an array using a specific range in Microsoft Excel using VBA. VBA PasswordProject Password in Microsoft Excel VBAThis article explains the usage of a project password in Microsoft Excel VBA. VBA ErrorOn Error Statement in Microsoft Excel VBAThis article explains the usage of the On Error statement in Microsoft Excel VBA. VBA MsgBoxMsgBox in Microsoft Excel VBAThis article explains the usage of MsgBox in Microsoft Excel VBA. VBA CellHow to Check if a Cell Is Empty in Microsoft Excel VBAThis article explains the ways to check if a cell is empty in Microsoft Excel VBA. VBA UnsortHow to Unsort Sorted Data in Microsoft Excel VBAThis article explains the ways to unsort sorted data in Microsoft Excel VBA. VBA NumberHow to Convert Text to Number in Microsoft Excel VBAThis article explains the ways to convert textual data to numbers in Microsoft Excel VBA. VBA StringHow to Check if a String Contains a Substring in VBAThis tutorial demonstrates how to return a boolean if a string contains another string in VBA. VBA PasswordHow to Unlock VBA Password Using VBA ScriptsThis tutorial demonstrates how to crack the password of a VBA script using VBA codes. VBA RowHow to Find the Last Row and Column in VBAThis tutorial demonstrates how to get the number of last used row and column in Excel VBA. VBA TextHow to Write Data to Text File Using Excel VBAThis tutorial demonstrates using VBA to generate text files. VBA ArrayHow to Sort the Elements of an Array and Arraylist in VBAThis tutorial demonstrates how to sort the elements of an array and arraylist in VBA. VBA FindHow to Find a Value in a Column Using Excel VBAThis tutorial demonstrates different ways to find a value in a column in VBA. VBA ArrayHow to Declare and Initialize String Array in VBAThis tutorial demonstrates how to declare and initialize string array in VBA. VBA DictionaryHow to Create and Utilize a Dictionary in VBAThis tutorial demonstrates how to declare and utilize a Dictionary in VBA. VBA Number FormatHow to Utilize Number Formats in Excel VBAThis tutorial demonstrates different ways in formatting numbers in Excel VBA.