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 Use for Each on an Array Using VBAThis article mentions how to use a For Each loop on an array that contains several elements in VBA. VBA XMLHow to Parse XML in Microsoft Excel VBAThis article explains how to parse XML in Microsoft Excel VBA. VBA LoopsLoops and Exit Loops in VBAThis tutorial demonstrates how to Exit a For, Do Until, Do While Loop in VBA. VBA OperatorIntroduction to Comparison Operators in VBAThis article describes the various comparison operators offered by VBA and discusses the <> operator in detail. VBA Auto FilterAuto Filter With Multiple Criteria in VBAThis tutorial demonstrates how to use auto filter with multiple criteria in VBA. VBA PasteSelection Paste Using VBAThis tutorial demonstrates how to paste selection in VBA. VBA ObjectFile System Object in VBAThis tutorial demonstrates what is file system object in VBA. VBA FunctionThe Use of Function in VBAThis tutorial demonstrates how to create and use a Function for object and non-object data types.