VBA

2. Tags
3. VBA

VBA Number

• Convert Text to Number in Microsoft Excel VBA

VBA Unsort

• Unsort Sorted Data in Microsoft Excel VBA

VBA XML

• Parsing XML in Microsoft Excel VBA

VBA Array

• Use for Each on an Array Using VBA
• Create an Array From a Specific Range in Excel Using VBA
• Return Array From Function in VBA
• Get the Array Length in VBA
• Declare and Initialize String Array in VBA
• Sort the Elements of an Array and Arraylist in VBA

VBA Integer

• Convert Integer to String Data Type in Microsoft Excel VBA

VBA Progress Bar

• Create a Progress Bar in Excel VBA

VBA Cell

• Different Ways to Check if a Cell Is Empty in Microsoft Excel VBA
• Change Cell Color in VBA
• Set Formulas for a Cell in VBA

VBA CSV

• Import CSV Into Access VBA

VBA File

• Loop Through Files in a Folder Using VBA
• Read a Text File Line by Line in VBA
• Copy File in VBA
• Delete File in VBA
• Check if a File Exists Using VBA

VBA MsgBox

• MsgBox in Microsoft Excel VBA

VBA Error

• On Error Statement in Microsoft Excel VBA
• Install and Register MSCOMCT2.OCX File

VBA Password

• Project Password in Microsoft Excel VBA
• Unlock VBA Password Using VBA Scripts

VBA Save

• Save as in Microsoft Excel VBA

VBA Regex

• Use Regular Expressions in Excel VBA

VBA Window

• Clear the Immediate Window Using VBA

VBA JSON

• Parse JSON With VBA

VBA VLookup

• Reference Another Sheet in VLookup Using VBA

VBA Excel

• Convert a Column Number to Letter in Excel Using VBA
• VBA Copy Past Values
• Clear Clipboard in VBA
• Create New Excel Sheet in VBA

VBA Operator

• Introduction to Comparison Operators in VBA
• VBA Use AND Operator in IF Statement

VBA Workbook

• Open a Workbook by Specifying Its Path in Microsoft Excel Using VBA

VBA Userform

• Call Userform Initialize in VBA

VBA List

• Array List in VBA

VBA String

• Use Quotes in Strings in VBA
• Compare Strings in VBA
• Concatenate String in VBA
• Convert String to Number in VBA
• Check if a String Contains a Substring in VBA

VBA Row

• Count Rows in VBA
• Delete a Row in VBA
• Find the Last Row and Column in VBA

VBA Call

• Call Sub in VBA

VBA Function

• The Sum Function in VBA
• Exit Sub in VBA
• Add New Line in VBA
• VLOOKUP Function in VBA
• The Use of Function in VBA

VBA Duplicates

• Remove Duplicates in VBA

VBA Refresh

• Refresh All Pivot Tables in VBA

VBA Round Up

• Round Up in VBA

VBA Sheet

• Check if Sheet Exists in VBA

VBA Variable

• Create Variable Range in VBA
• Global Variable in VBA

VBA Worksheet

• Set Worksheets in VBA
• Activate Worksheet in Excel in VBA

VBA PDF

• Open PDF in VBA

VBA Protect

• Protect Macro in VBA

VBA Auto Filter

• Auto Filter With Multiple Criteria in VBA

VBA Column

• Count Columns in VBA
• Find the Last Row and Column in VBA

VBA Selection

• Selection of Cells in VBA

VBA Memory

• Out of Memory in VBA

VBA Object

• File System Object in VBA

VBA Paste

• Selection Paste Using VBA

VBA Sort

• Sort Data Range by Specific Column in Excel VBA

VBA SQL

• Use Excel VBA to Run SQL Query

VBA Try Catch

• Use Try-Catch in VBA

VBA Debugging

• Print Output in the Immediate Window in VBA

VBA Number Format

• Utilize Number Formats in Excel VBA

VBA Dictionary

• Create and Utilize a Dictionary in VBA

VBA Find

• Find a Value in a Column Using Excel VBA

VBA Loops

• Loops and Exit Loops in VBA

VBA Text

• Write Data to Text File Using Excel VBA

VBA Delay

• Add Delay During Code Execution Using VBA

VBA Comment

• Utilize Comments on VBA