All Vba Solutions on Gang of Coders

Total of 149 Vba Solutions

How can I get this 8 year old VBA 64-bit compiler bug fixed?

Excel Vba Ms Access 64 Bit

Where does VBA Debug.Print log to?

Vba Debugging Ms Office

VBA shorthand for x=x+1?

Programmatic Access To Visual Basic Project Is Not Trusted

Vba Excel Programmatically Created

Create excel ranges using column numbers in vba?

Excel Date Conversion from yyyymmdd to mm/dd/yyyy

Excel Excel 2007 Vba

Excel VBA code to copy a specific string to clipboard

Excel Clipboard Vba

Wait until ActiveWorkbook.RefreshAll finishes - VBA

Iterating through populated rows

Add newline to VBA or Visual Basic 6

How to "flatten" or "collapse" a 2D Excel table into 1D?

vba: get unique values from array

Vba Algorithm Excel Unique

VBA Check if variable is empty

Vba Object Variables Is Empty

How can I generate GUIDs in Excel?

How to Remove Line Break in String

How do I get the old value of a changed cell in Excel VBA?

Populating VBA dynamic arrays

VBA collection: list of keys

Vba Collections

Returning a regex match in VBA (excel)

Regex Excel Vba

Easiest way to loop through a filtered list with VBA?

Getting Excel to refresh data on sheet from within VBA

Does VBA have Dictionary Structure?

Vba Dictionary Data Structures Vb6

Regular Expression Rules in Outlook 2007?

Regex Vba Vbscript Outlook Outlook 2007

Does the VBA "And" operator evaluate the second argument when the first is false?

Excel Vba Operators

Delete Sheets and avoid Excel asking the user to confirm, using custom messages instead

How do I find the last column with data?

VBA to copy a file from one directory to another

Using Excel VBA to run SQL query

Sql Sql Server Vba Excel

Loop through files in a folder using VBA?

Check if a string contains another string

What is the difference between .text, .value, and .value2?

Difference between Visual Basic 6.0 and VBA

Excel VBA - exit for loop

Excel Vba For Loop

Error in finding last used cell in Excel with VBA

Excel Vba Excel Formula

Can I simultaneously declare and assign a variable in VBA?

Vba Variable Declaration

How Do I Convert an Integer to a String in Excel VBA?

Vba String Type Conversion Integer

How to get the path of current worksheet in VBA?

Excel VBA App stops spontaneously with message "Code execution has been halted"

Function to convert column number to letter?

Excel Vba Excel Udf

What does the keyword Set actually do in VBA?

Vba Variable Assignment

How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops

Regex Excel Vba

How can I send an HTTP POST request to a server from Excel using VBA?

Excel Vba Http Post Serverxmlhttp

Declare and Initialize String Array in VBA

Arrays Vba Initialization

When editing Microsoft Office VBA, how can I disable the popup "Compile error" messages?

How do I declare a global variable in VBA?

Excel Vba Scope Global Variables

How do I put double quotes in a string in vba?

Excel Vba Double Quotes

Test or check if sheet exists

Excel Vba Scripting

Deleting a file in VBA

Vba File Io Delete File File Exists

Display milliseconds in Excel

How to create and write to a txt file using VBA

How to avoid using Select in Excel VBA

Is VB really case insensitive?

vb.net Vba Case Sensitive Case Insensitive

Loop through each row of a range in Excel

Excel Vba Loops Excel 2003

Break out of a While...Wend loop

Excel Vba While Loop

How to suppress Update Links warning?

How do I use FileSystemObject in VBA?

Excel Vba Filesystemobject

Microsoft Excel ActiveX Controls Disabled?

Excel Vba Activex

Is there a way to crack the password on an Excel VBA Project?

Excel Vba Passwords

VBA - how to conditionally skip a for loop iteration

Vba Conditional Loops

Parsing an ISO8601 date/time (including TimeZone) in Excel

Excel Datetime Vba Timezone Iso8601

How to add a custom Ribbon tab using VBA?

Excel Vba Excel 2007 Ribbonx

How to pause for specific amount of time? (Excel/VBA)

What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Excel Vba Excel 2010 Activex Form Control

What is the equivalent of "!=" in Excel VBA?

Excel Vba Function Syntax Inequality

VBA check if object is set

How do you test running time of VBA code?

Optimization Testing Vba Profiling Performance

automatically execute an Excel macro on a cell change

Excel Vba Automation

Hash Table/Associative Array in VBA

Vba Hash Hashtable Associative Array

How to add a reference programmatically using VBA

Excel Vba Reference

VBA array sort function?

Arrays Sorting Vba Vb6 Ms Project

What is the difference between dim and set in vba

Pass arguments to Constructor in VBA

Vba Class Oop Constructor Factory

Refreshing all the pivot tables in my excel workbook with a macro

Excel Vba Refresh

Test if string begins with a string?

"Can't find Project or Library" for standard VBA functions

Excel Vba Reference Namespaces

Check if the file exists using VBA

Getting Error 3340 Query ' ' is corrupt while executing queries DoCmd.RunSQL

Save each sheet in a workbook to separate CSV files

Iterate over VBA Dictionaries?

How do I test if optional arguments are supplied or not?

Vba Function Vb6 Arguments Optional Arguments

How to put a tooltip on a user-defined function

How to parse XML using vba

Xml Vba Parsing Xml Parsing

Excel Macro : How can I get the timestamp in "yyyy-MM-dd hh:mm:ss" format?

How to merge rows in a column into one cell in excel?

What are some good patterns for VBA error handling?

Way to run Excel macros from command line or batch file?

Excel Vba Batch File Command Line

How can I create a progress bar in Excel VBA?

Parsing JSON in Excel VBA

Json Excel Parsing Vba Object

Open Excel file for reading with VBA without display

Excel Vba File Io

Why Use Integer Instead of Long?

Integer Long Integer Integer Overflow Vba

Get length of array?

Excel Vba Ms Access

How can I concatenate strings in VBA?

Convert cells(1,1) into "A1" and vice versa

Excel: How to check if a cell is empty with VBA?

How can I URL encode a string in Excel VBA?

Excel Vba Url Encoding Urlencode

Detect whether Excel workbook is already open

Retrieve calendar items (Outlook API, WebDAV) displaying strange behaviour

Vba Outlook Exchange Server Webdav

Refresh Excel VBA Function Results

Excel Vba User Defined-Functions

Excel column number from column name

Is there a need to set Objects to Nothing

Vba Vbscript Vb6

How to add a named sheet at the end of all Excel sheets?

Excel Vba Worksheet

What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?

Vba Vb6 Scope Access Modifiers

How to use workbook.saveas with automatic Overwrite

Excel Vba Excel 2010

How do I express "if value is not empty" in the VBA language?

Call a Subroutine from a different Module in VBA

Vba Module Call

How can I use a for each loop on an array?

How to extract file name from path?

Use VBA to Clear Immediate Window?

Excel Vba Immediate Window

Multi-threading in VBA

Multithreading Vba Excel

Convert string to int if string is a number

How to change Format of a Cell to Text using VBA

How to get current working directory using vba?

Determining whether an object is a member of a collection in VBA

Vba Object Ms Access Collections

How to use the Implements in Excel VBA

Excel Vba Interface

Using a UDF in Excel to update the worksheet

Creating an Array from a Range in VBA

Arrays Excel Vba Range

Excel: the Incredible Shrinking and Expanding Controls

Excel Vba Excel 2010 Excel 2007 Excel 2003

How to clear the entire array?

Arrays Excel Vba

Continue For loop

Vba Loops For Loop Next

Is it possible to write Excel VBA Code in Visual Studio

Vba Visual Studio Excel

Why cells(1,1) = 500 * 100 causes overflow but 50000*100 doesn't?

How can I find last row that contains data in a specific column?

How to check for empty array in vba macro

Alternative IDE for VB6 and VBA

Vba Vb6 Ide Vbe

How to activate a specific worksheet in Excel?

Protecting cells in Excel but allow these to be modified by VBA script

Rounding a number to the nearest 5 or 10 or X

How to continue the code on the next line in VBA

Removing the password from a VBA project

Vba Security Excel Password Protection

Is it possible to declare a public variable in vba and assign a default value?

Vba Variables Default Value Public Variable Declaration

Read/Parse text file line by line in VBA

How can I color dots in a xy scatterplot according to column value?

Vba Excel Charts Excel Formula

Running an Excel macro via Python?

Python Excel Vba Python 2.7

How to name an object within a PowerPoint slide?

Use of symbol # (hash) in VBA Macro

What are .NumberFormat Options In Excel VBA?

Determining the full type of a variable

What does the Excel range.Rows property really do?

Vba Excel Ole Automation

How to find if an array contains a string

Arrays Vba Substring

Levenshtein Distance in VBA

Vba Excel Levenshtein Distance

How to comment and uncomment blocks of code in the Office VBA Editor

Excel cell from which a Function is called

Properly Handling Errors in VBA (Excel)

Save text file UTF-8 encoded with VBA

Loop through each cell in a range of cells when given a Range object

How to add a button programmatically in VBA next to some sheet cell data?

Excel Vba Button

How to return a result from a VBA function

Excel Vba Function Return Return Value

Return Index of an Element in an Array Excel VBA

Arrays Excel Vba Indexing Find

Excel function to make SQL-like queries on worksheet data?

Sql Excel Vba Function