VBA

2. Tags
3. VBA

VBA Number

• How to Convert Text to Number in Microsoft Excel VBA

VBA Unsort

• How to Unsort Sorted Data in Microsoft Excel VBA

VBA XML

• How to Parse XML in Microsoft Excel VBA

VBA Array

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

VBA Cell

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

VBA Integer

• How to Convert Integer to String Data Type in Microsoft Excel VBA

VBA Progress Bar

• How to Create a Progress Bar in Excel VBA

VBA CSV

• How to Import CSV Into Access using VBA

VBA File

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

VBA Save

• How to Save as in Microsoft Excel VBA

VBA Regex

• How to Use Regular Expressions in Excel VBA

VBA MsgBox

• MsgBox in Microsoft Excel VBA

VBA Error

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

VBA Password

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

VBA Window

• How to Clear the Immediate Window Using VBA

VBA JSON

• How to Parse JSON With VBA

VBA VLookup

• How to Reference Another Sheet in VLookup Using VBA

VBA Excel

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

VBA Workbook

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

VBA Operator

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

VBA Userform

• How to Call Userform Initialize in VBA

VBA List

• Array List in VBA

VBA String

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

VBA Row

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

VBA Call

• How to Call Sub in VBA

VBA Function

• The Sum() Function in VBA
• How to Exit Sub in VBA
• How to Add New Line in VBA
• The VLOOKUP Function in VBA
• The Use of Function in VBA

VBA Duplicates

• How to Remove Duplicates in VBA

VBA Refresh

• How to Refresh All Pivot Tables in VBA

VBA Round Up

• How to Round Up Numbers in VBA

VBA Sheet

• How to Check if Sheet Exists in VBA

VBA Variable

• How to Create Variable Range in VBA
• Global Variable in VBA

VBA Worksheet

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

VBA PDF

• How to Open PDF in VBA

VBA Protect

• How to Protect Macro in VBA

VBA Auto Filter

• Auto Filter With Multiple Criteria in VBA

VBA Column

• How to Count Columns in VBA
• How to 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

• How to Sort Data Range by Specific Column in Excel VBA

VBA SQL

• How to Use Excel VBA to Run SQL Query

VBA Try Catch

• How to Use Try-Catch in VBA

VBA Debugging

• How to Print Output in the Immediate Window in VBA

VBA Number Format

• How to Utilize Number Formats in Excel VBA

VBA Dictionary

• How to Create and Utilize a Dictionary in VBA

VBA Find

• How to Find a Value in a Column Using Excel VBA

VBA Text

• How to Write Data to Text File Using Excel VBA

VBA Loops

• Loops and Exit Loops in VBA

VBA Delay

• How to Add Delay During Code Execution Using VBA

VBA Comment

• How to Utilize Comments on VBA