Search:

• Search Results

VBA Examples

• Learning Excel & VBA
  • Excel VBA Examples
    • Basics
      • If, ElseIf, Else (Ultimate Guide to If Statements)
      • Value Paste & PasteSpecial
      • Cut, Copy, Paste from a Macro
      • VBA Save File - 20 Easy Examples
    • VBA Coding Concepts
      • Commenting in VBA
      • Creating (Custom) User Defined Functions (UDFs)
      • Excel Named Ranges and Programming
      • How to Rename or Delete a Module or Form
      • Opening & Using the Visual Basic Editor (VBE) in Excel
      • Return a Value from a Sub Procedure
      • Shortcuts for the Visual Basic Editor
      • Call Function from a Sub
      • Function - Call, Return Value, & Parameters
      • Object Model
      • On Error - Error Handling Best Practices
      • Private vs Public Procedures (Subs & Functions)
      • Select Case Statement
      • Sub Procedure
      • What is a VBA Module?
      • What is a VBA Project? (And How to Edit)
      • Hide a Macro
      • Language References
      • Modify the Right-Click Menu to Call a Macro
      • Run a Macro from a Macro
      • Run a Macro Line by Line
      • Wait, Delay, Create a Timer While Running Code
      • Debug.Print and Immediate Window
      • VBA DoEvents
      • VBA End
      • VBA Exit Sub or Function
      • VBA On Error Exit Sub
      • VBA Option Explicit
      • VBA: Improve Speed & Other Best Practices
    • Loops
      • VBA For Loop - Loop Through a Range of Cells
      • Loops - Ultimate Guide
      • For Each Examples (Quick Reference)
      • VBA Exit For
      • VBA Exit Loop
      • While Wend Loop
    • Ranges and Cells
      • Ranges and Cells - Ultimate Guide
      • Formulas - Ultimate Guide
      • Union and Intersect
      • Resize Range
      • Autofill with a Macro
      • Change a Cell Background Color
      • ClearFormats - Remove Formatting For Each Cell In Range
      • Conditional Formatting - Highlight Duplicates in a Range
      • Delete All Named Ranges
      • Delete Hyperlinks
      • Determine Start and End Column of a Merged Cell
      • Excel's Color Scheme
      • Find the Maximum Value For Each Column in a Range
      • Format Painter
      • Get the Active Cell's Column or Row
      • Resize an Object to a Range Size
      • Select All Cells
      • Sum by Color
      • Test if Selection is a Range or Object
      • Cell Value - Get, Set, or Change
      • ClearContents / Clear Cells
      • Copy Destination (Copy Range to Another Sheet)
      • Current Region
      • Dynamic Range
      • VBA Function - Populating a Range With Random Values
      • Highlight Cell
      • VBA Merge Cells & Unmerge Cells
      • Offset Range or Cell
      • Range / Cell Address
      • Range.End (xlDown, xlUp, xlToRight, xlToLeft)
      • VBA Routine to return Column Letter of Cell
      • VBA Select Range or Cells
      • VBA Union - Join Multiple Ranges
      • VBA Wrap Text
      • Activecell Offset VBA
    • Rows & Columns
      • Select (and work with) Entire Rows & Columns
      • Delete or Insert Rows Based on Cell Value
      • Delete Rows that Meet Certain Criteria in VBA
      • Hide / Unhide Columns & Rows
      • Unhide All Rows / Columns
      • Autofit Columns
      • Count the rows in a Selection
      • Delete Blank Rows
      • Select Every 5th Row
      • Select Non Contiguous Columns
      • Copy / Paste Rows & Columns
      • Delete Entire Row or Column
      • Group Rows & Columns
      • Insert Row or Column
      • VBA Set Column Width or Row Height
      • VBA Used Range - Count Number of Used Rows or Columns
    • Sheets
      • Sheets - The Ultimate Guide
      • Count the Sheets in a Workbook
      • Create a Hyperlink Menu of Worksheets
      • Hide (or Unhide) a Worksheet
      • Hide WorkSheet Tabs
      • How to Use Worksheet Functions (and a Full List)
      • Loop Through all Worksheets with For Each
      • Macro to List all Sheets in a Workbook
      • Send Worksheets by Email as Separate Workbooks
      • Sort Sheets Alphabetically
      • Unhide All Worksheets
      • Clear Entire Sheet
      • VBA Copy Worksheet
      • VBA Delete or Clear Worksheet
      • Get Sheet Name / Rename Sheet
      • VBA Protect / Unprotect Worksheets
      • VBA Routine to Add and Name Worksheets
      • VBA Select Sheet, Activate Sheet, and Get Activesheet
      • Worksheet Range
      • VBA: Set the Default Sheet When a WorkBook Opens
      • How to Sort Tabs / Worksheets with a VBA Macro
    • Workbooks
      • Combine Workbooks
      • Create New Workbook (Workbooks.Add)
      • Activate Workbook
      • ActiveWorkbook vs. ThisWorkbook
      • VBA Open / Close Workbook
      • Workbook Name (Get, Set, without Extension)
      • Workbook Protection (Password Protect / Unprotect)
      • Working with Workbooks (The Workbook Object)
    • Arrays
      • Arrays
      • Array Examples
      • Collections
      • ArrayList
      • Array of Objects
      • Variant Array
      • Dynamic Array (Redim & Redim Preserve)
      • Declare & Initilize String Array
      • Declare (Dim), Create, and Initialize Array Variable
      • Array Length / Size
      • Assign Range to Array
      • Clear Array - Erase Function
      • Loop Through Array / For Each Item in Array
      • Sort Array
      • Transpose Array
      • Search for (Find) Value in Array
      • Populate Array with Unique Values from Column
      • Remove Duplicates From Array
      • Function Return Array
      • Multi-Dimensional Array (2D Arrays)
      • Output (Print) Array to Range
    • Errors
      • Try Catch Errors
      • Object Required Error
      • Syntax Error VBA
      • Type Mismatch (Run-time Error 13)
      • Automation Error
      • Compile Error
      • Error 1004 - Application-Defined or Object-Defined Error
      • Ignore Error
      • On Error Resume Next or Goto 0
      • Out of Memory Error
      • Throw / Raise Error - Err.Raise - Custom Error Msg
      • Can't Find Project or Library - VBA Compile Error
      • Compile Error in Hidden Module - VBA
      • Fix Error 400
      • Fix VBA Error 438 - Object Doesn't Support Property or Method
      • Fix VBA Run Time Error 32809
      • Fix VBA Run Time Error 57121
    • Variables
      • Dim Declare Variable
      • Determine a Variable's Underlying Type
      • VBA Array Variables
      • Boolean Data Type (Dim Variable)
      • Constant
      • VBA Constant Expression Required
      • VBA Data Types, Variables and Constants
      • VBA Date Variable
      • Double Data Type (Dim Variable)
      • VBA Global Variable
      • Int / Integer Data Type (Dim Variable)
      • Long Data Type (Dim Variable)
      • VBA Public Variable - Use a Variable in Multiple Modules or Subs
      • VBA Range Object Variables (Dim / Set Range)
      • Set Object Variables - Workbooks, Worksheets, & More
      • Single Data Type (Dim Variable)
      • VBA Static Variable
      • String Data Type (Dim Variable)
      • Variant Data Type (Dim Variable)
    • Settings
      • Get and Change User Name with VBA
      • Display Status Bar Message
      • Modify the titlebar
      • Prevent warning messages from a macro
      • Turn Automatic Calculations Off (or On)
      • Turn Formula Bar Off (or On)
      • Turn off Screen Updating
      • VBA Turn Scroll Bars On or Off
    • Text and Strings
      • Split String into Cells
      • Prevent VBA Case Sensitive - Option Compare Text
      • Extract Number From String
      • Find the nth Word in a String of Text
      • Force Proper, Upper, or Lower case automatically
      • Line Break or Line Feed in a Message Box
      • Loop Through a String
      • Remove Characters from Left or Right Side of Variable Length String
      • Reverse a String of Text
      • VBA Char / Chr Function
      • VBA Compare Strings, StrComp
      • VBA Comparison Operators - Not Equal to & More
      • VBA Concatenate Text Strings Together (& - Ampersand)
      • Convert Integer (Number) to String
      • Convert String to Date
      • Convert Text String to Number
      • VBA Function To Calculate Number of Words in a String
      • VBA INSTR - Find Text in a String
      • VBA Like Operator
      • VBA Logical Operators - OR, AND, XOR, NOT, IS, & LIKE
      • VBA New Line / Carriage Return
      • Parse String
      • VBA Space Function - Add Spaces to a String
      • VBA Strings and Substrings Functions
      • Text to Columns
      • Trim, LTrim, and RTrim Functions - Remove Spaces From Text
      • VBA Upper, Lower, and Proper Case - Case Functions
    • View
      • ActiveWindow.WindowState
      • Display (or Exit) Fullscreen
      • Freeze Panes
      • Hide Excel (The Entire Application)
      • Page Break Preview Mode On or Off
      • Scroll Vertically and Scroll Horizontally
      • Zoom - Fit Selection
      • Zoom in and Out of Worksheets
    • Files
      • FileSystem Object
      • Move Files with VBA FileSystemObject (MoveFile)
      • Convert Excel to CSV (Comma Delimited Text File)
      • Create Text File with CreateTextFile
      • Delete files from the hard drive
      • Export Range to CSV (Delimited Text File)
      • Import File Names to Clickable Links
      • List of all files contained within a Directory
      • Read Text File into String
      • Read Text File Line by Line
      • Test if Workbook is Open by Workbook Name
      • Validate Filenames
      • Write to Text File
      • VBA Check if File or Folder Exists
      • Combine Multiple Excel Files into One Workbook
      • Copy a Folder with CopyFolder (FSO)
      • VBA Copy File / Workbook
      • VBA Delete File / Workbook
      • Delete Folder with DeleteFolder (FSO)
      • FileCopy Statement
      • Get File Name with GetFileName (FSO)
      • GetFolder & GetFile (Get File & Folder Properties)
      • VBA List Files in Folder
      • VBA Open File Dialog Box
      • Open Text File with OpenTextFile
      • Read Text File (Read, Parse, and Import)
      • VBA Rename File
    • Shapes, Charts, Objects
      • VBA AutoFilter
      • VBA Guide For Charts and Graphs
      • VBA Guide to Pivot Tables
      • VBA Objects
      • Excel Add VBA Button
      • How to use VBA Controls in UserForms
      • Create a Bar Chart
      • Delete All Autoshapes
      • Programmatically Draw Boxes with Code
      • Listbox - Selected Item
      • VBA Tables and ListObjects
      • TextBox
    • Formatting
      • Conditional Formatting
      • Bold
      • Cell Borders
      • Cell Font - Change Color, Size, Style, & More
      • Center Text - Cell Alignment (Horizontal & Vertical)
      • Display Page Breaks Setting
      • Format Cells
      • Format Date
      • Format Time
    • Events
      • Events
      • Exit Without Save Prompt
      • Force a Workbook to Save Before Close
      • Run a Macro when Excel Closes - Auto_Close
      • Run a macro when Excel starts
      • VBA Worksheet Change Event - Run a Macro When a Cell Changes
      • VBA: Show or load a form when Excel starts
    • UserForms, MsgBoxes & Controls
      • Make Userform Transparent
      • Yes No Message Box (Msgbox)
      • VBA InputBox - Get Input from a User
      • Creating VBA Userforms
      • Option Button Excel VBA
      • Spin button Excel VBA
      • VBA Checkbox
      • VBA ComboBox
      • VBA Listbox
      • VBA Open or Close UserForm
    • Misc
      • Clear Clipboard
      • Pause (Break / Stop) & Resume a Macro
      • Save As (Print) to PDF
      • ColorIndex Codes List
      • Format Numbers
      • How to Install (or Uninstall) a VBA add-in (.xlam file) for Microsoft Excel
      • How to use VBA Structures
      • Removing Duplicate Values in Excel VBA
      • Speed up your VBA Code
      • Add or Remove Cell Comments
      • All Operators Explained
      • Build a Custom Import Interface
      • Check if Office App is Running
      • Dialog Box
      • Get Today's Date (Current Date)
      • Pivot Table Filter
      • Refresh Pivot Table / All Pivot Tables
      • Refresh Pivot Table when Data Changes
      • Using Goal Seek in VBA
      • Using the Analysis ToolPak in VBA
      • Advanced Filter
      • Application.CutCopyMode = False
      • Calculate - Now, Workbook, Worksheet, or Range
      • Call / Run Sub From another Subroutine
      • Copy to Clipboard
      • Find Value in Column
      • GoTo a Line Label
      • IIF Function
      • Input Statement
      • is Nothing
      • Is Operator
      • Line Input Statement
      • Multiple (Nested) If Statements
      • Project Password / Protect code
      • Reference
      • Solver
      • Wait & Sleep Functions - Pause / Delay Code
      • Wildcards
      • With / End With Statement
      • What is the Difference Between VB and VBA?
      • Personal Macro Workbook
      • Check Spelling
      • Turn Off AutoFilter / Clear Filters
      • VBA Drop Down List (Data Validation)
      • VBA Hyperlinks
      • VBA Random Number
    • Functions
      • Check if Sheet and/or Range Exists Function
      • IsEmpty Function
      • Using Isnumeric and Isnumber in VBA
      • Compare Dates
      • Abs Function
      • AVERAGE, AVERAGEA, AVERAGEIF
      • CCur Function
      • CDbl Function - Convert to Double
      • CDec Function
      • ChDir Statement
      • ChDrive Statement
      • CInt Function - Convert to Integer
      • CLng Function - Convert Expression to Long
      • CLngLng Function
      • Close Statement
      • COUNT Function
      • COUNTIF and COUNTIFS Functions
      • CreateObject (Create Object)
      • CSng Function
      • CurDir Function
      • VBA Date Functions
      • DateAdd Function
      • DateDiff Function
      • DatePart Function
      • DateSerial Function
      • DateValue Function
      • Day Function
      • Dir Function
      • Environ Functions
      • EOF Function
      • FileDateTime Function
      • Filter Arrays
      • Format Function
      • FreeFile Function
      • VBA Function to Show Cell Formula
      • GetAttr Function
      • Hex Function
      • Hour Function
      • InStrRev Function - Find Text From Right
      • IsArray Function
      • IsDate Function
      • IsEmpty Function
      • IsError Function
      • IsMissing Function
      • IsNull Function
      • IsNumeric Function
      • Join Function
      • LBound Function
      • Left Function - Extract Text From Left
      • Len Function - Get String Length
      • LOF Function
      • Log Function
      • Mid Function - Extract Characters From Middle of String
      • Minute Function
      • MkDir Statement
      • Month Function
      • MonthName Function
      • Now Function - Get Current Date & Time
      • Open Statement
      • Print Statement
      • Randomize Statement
      • Replace Function - Replace String
      • Right Function - Extract Text From Right
      • Rnd Function
      • Round Function
      • Round, RoundUp, and RoundDown
      • Second Function
      • Split Function - Split String of Text into Array
      • Sqr Function
      • Sum Function (Ranges, Columns, & More)
      • SUMIF and SUMIFS Functions
      • Switch Statement
      • Text Function
      • Time Function
      • Time Functions
      • Timer Function
      • TimeSerial Function
      • TimeValue Function
      • TypeName
      • TypeOf
      • UBound & LBound Functions
      • Val Function
      • VarType
      • Weekday Function
      • WeekdayName Function
      • Write Statement
      • Year Function
      • Vlookup - Multiple Results with VBA
      • Vlookup Multiple Criteria with VBA UDF
    • Advanced Programming
      • Early Late Binding
      • Class Constructor
      • Class Module Tutorial & Examples
      • Matrix - Create & More
      • Shell
      • Convert Matrix to Vector
      • VBA Regex
      • VBA SendKeys
    • Internet & Email
      • Automate Internet Explorer (IE) Using VBA
      • Send Emails from Excel through Gmail
      • Send Emails from Excel through Outlook
  • Word VBA Examples
    • Word Bookmarks - VBA Macros to Add, Delete, Goto, Modify
    • Word Macro to Open Word Document
    • Word VBA Macros - Add New Document
    • Word VBA Macros - Count Words in Selection
    • Word VBA Macros - Find, Find & Replace
    • Word VBA Macros - SaveAs (PDF or New File Name)
    • Word VBA Macros - Tables: Add, Select, Loop, Insert From Excel
    • Word VBA Macros - Templates (Make New)
    • Word VBA Macros - TextBox: Add, Delete, Write
  • PowerPoint VBA Examples
    • PowerPoint VBA (Macros) Tutorial
    • Useful PowerPoint Macro Examples
    • Automating PowerPoint from Excel
  • Access VBA Examples
    • Access VBA Recordsets - Open, Count, Loop and More
    • Access Import / Export Excel - Query, Report, Table, and Forms
    • Access Open / Close Form
    • Access Open Excel File
    • Access VBA Database - Open, Connect, Login, & More
    • Access VBA Findfirst
    • Access VBA Me
    • Access VBA Query
    • Access VBA Refresh Form
    • Access VBA Reports - Print, Export, Filter
    • Access VBA SQL Examples
    • Access VBA Tables - Update, Count, Delete, Create, Rename, Export