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 RefreshHow to Refresh All Pivot Tables in VBALearn how to refresh all pivot tables in VBA with our comprehensive guide. Discover step-by-step methods to automate the refresh process, ensuring your data remains current. Perfect for Excel users looking to streamline their reporting and analysis tasks. Mastering this skill can significantly enhance your productivity and accuracy in data management. VBA DuplicatesHow to Remove Duplicates in VBALearn how to remove duplicates in VBA with our comprehensive guide. We cover various methods, including the built-in RemoveDuplicates method, looping through rows, and using Dictionary objects. Enhance your Excel data management skills and ensure your datasets remain clean and accurate. Perfect for beginners and experienced users alike. VBA ArrayHow to Return Array From Function in VBALearn how to return an array from a function in VBA with this comprehensive guide. Discover practical examples, understand array declaration, and see how to utilize arrays effectively in your VBA projects. Enhance your coding skills and streamline data management with our step-by-step instructions. VBA RowHow to Count Rows in VBALearn how to count rows in VBA with our comprehensive guide. Explore various methods including using the Count property, End property, and counting with criteria. Enhance your Excel automation skills and manage your data more effectively. Whether you're a beginner or an experienced user, this article will provide you with the essential techniques to streamline your workflow. VBA UserformHow to Call Userform Initialize in VBAThis article demonstrates how to use UserForm_Initialize in VBA to enhance your applications. Learn to set initial values, customize appearance, and load dynamic data in UserForms for a better user experience. Perfect for beginners and experienced developers alike. VBA FunctionHow to Exit Sub in VBALearn how to effectively use Exit Sub in VBA to manage code execution flow. This article provides clear examples and explanations for beginners and experienced developers alike. Discover how to implement Exit Sub in error handling and conditional statements to create efficient and user-friendly applications. Enhance your VBA skills today! VBA CallHow to Call Sub in VBALearn how to call a Sub in VBA with our comprehensive guide. We cover direct calls, passing arguments, and event-driven calls, complete with examples and explanations. Enhance your VBA skills and streamline your coding process today! VBA PDFHow to Open PDF in VBAThis tutorial demonstrates how to open PDF files in VBA using various methods, including Shell function, CreateObject, and API calls. Learn to automate your workflow effectively with clear examples and detailed explanations. Perfect for Excel users looking to enhance their VBA applications. 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 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 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 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.