Examples of programming questions in vba

When is a MailItem not a MailItem?
Loading addins when Excel is instantiated programmatically
Making sure public VBA methods don't show up in the list of Excel macros
Write a formula in an Excel Cell using VBA
What Excel VBA actions are possible on hidden worksheets or workbooks?
Read lines from a text file but skip the first two lines
Hidden features of VBA
VBA: Using WithEvents on UserForms
VBA editor auto-deletes spaces at the ends of lines
Executing Word Mail Merge
What is the purpose of BOUND COLUMN property of listbox in MS Access?
VBA Shell and Wait with Exit Code
How to fall through a Select Case in Excel VBA?
Excel VBA: how to programmatically remove the marching ants after range.copy
Understanding what response codes come back from MsgBox
Forcing Garbage Collection
Convert image (jpg) to base64 in Excel VBA?
With VBA, find the version of the MySQL ODBC driver installed in Windows
neat way to get last friday's date
Using Application.Run in Excel VBA when workbook name contains spaces
How to get address of cell which calls a VBA Functions in a Excel sheet
running a macro from an add-in
Trim Cells using VBA in Excel
Can VBA Reach Across Instances of Excel?
How to loop though a table and access row items by their column header?
Formatting - add comma, 2 decimal places to cell values vb.net excel interop
VBA Error Handling not working in Excel
Calling web service using VBA code in Excel 2010
Creating and Naming Worksheet in Excel VBA
VBA: Copy paste without clipboard
Book list - getting book details from amazon using Excel VBA barcode lookups
How to deal with single quote in Word VBA SQL query?
Getting the unicode value of a char in VB
Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel
how to make VBA code compatible for office 2010 - 64 bit version and older office versions
IsDate function returns unexpected results
How can I run VBA code each time a cell gets its value changed by a formula?
Parsing XML in VBA
How do I call an Oracle stored procedure from an Excel VBA script?
VBA Cell address of Max()
How to push value into non pre specific array size?
Read XML Attribute VBA
How to check all fields of the recordset from ADO query?
Add references programmatically
VBA - Returning array from Property Get
Changing bar colors in bar graph
Excel VBA: Parsed JSON Object Loop
How do I delete all characters after the first space in a cell?
VBA Excel - Word Wrap
How to delete cell contents in Word with VBA?
Use of Like * Works in MS-Access but Not VBA
VBA Shell function in Office 2011 for Mac
How to count the number of rows in excel with data?
Switching sheets in Excel VBA
How to check if a Paragraph is in a Table or not in MS-Word macro?
Run time error 1004
Copying and pasting data using VBA code
Parse CSV, ignoring commas inside string literals in VBA?
Does the VBA "And" operator evaluate the second argument when the first is false?
Write contents of immediate window to a text file
Can I make Excel scroll smoothly without using middle-click?
Could Anyone Show List of Button Face Id in Excel 2010
VBA Excel VerticalAlignment = xlCenter not working
Open Outlook mail Item using EntryID, StoreID, and / or PR_ENTRYID
Determine whether user is adding or deleting rows
VBA Simple Copying one Range to Another Range
How to format excel spreadsheet cells using Excel Macro Module?
Excel vba - convert string to number
Language independent way to get "My Documents" folder in VBA Excel 2003
what is the opposite of IsNothing?
How to query a MS-Access Table from MS-Excel (2010) using VBA
Excel VBA change button size and location
Get the value between the brackets
How can I update text in a merged cell with VBA?
How do i determine if an error is in any cell in the entire workbook with Excel VBA
Get Workbook Connection Names
Excel VBA Regex Match Position
Export each sheet to a separate csv file
Current row in VBA Word
Exit / disable edit mode after double click handled event
Array in excel vba
Get reference to additional Inbox
How to use VBA to make a cell in Excel 2007 transparent
How to apply particular layout in powerpoint using vba?
Lookbehind on regex for VBA?
Column data moving to right with Excel VBA
ExecuteExcel4Macro to get value from closed workbook
How can I format a month in mmm format?
How can I define ENTER keypressed event for a dynamically chosen Cell in VBA for Excel
Pass vba Dictionary
reading and writing a csv file using FileSystemObject
Avoid extra "carriage return" in Print statement with Visual Basic?
How do I split a string ONLY after the first instance of the delimiter?
How to search on worksheet by VBA Code?
Closing a Userform with Unload Me doesn't work
Set a type in VBA to nothing?
Automatically execute some code after the UserForm is drawn
vba programming for visio
How to manage the no error case when handling errors in VBA?
How to specify the current directory as path in VBA?
How do I get my formula to always reference to the last sheet?
Remove whitespace in VBA excel
What does "range("F:F")" mean in an Excel macro?
VBA Dialogue FileFilter Partial File Name
How to run a macro automatically when the selections of pivot tables are changed
How to cancel a form close in Close Event?
Access ADO: operation is not allowed when the object is closed error message
How to extract substring in parentheses using Regex pattern
VBA String Limit
Object variable or with block not set -
Write Excel Addin with VBA and then Put a button that trigger it
numeric up down control in vba
Save As failed Excel VBA
VBA code doesn't run when cell is changed by a formula
Return without GoSub" when using subforms in Access
VBA to add new sheet in a closed excel without opening & get the sheet name added?
MS Access send email (not from outlook or user's email)
VBA Convert String to Date
Set breakpoint in VBA code programmatically
MSXML VBA: Validating XML against XSD: "The '' namespace provided differs from the schema's targetNamespace.
Make a new column without duplicates VBA?
How to determine if a worksheet Cell is Visible/Displayed in VBA?
Filling out a form ms-word VBA / Most effective intelligent navigation through Word
Is there an "On Close" event for MS Access VBA?
How to check a variable if it have a value or not?
Importing multiple CSV to multiple worksheet in a single workbook
Easy way to convert an Array to a Collection in VBA
Distinguish visible and invisible attachments with Outlook VBA
how to detect paste event in excel
VBA Powerpoint. How to get file's current directory path to a string in VBA?
Delete blanks from start and end of a string in vba
adding values to variable array VBA
Insert a Checkbox into every cell and assign it to that cell
How does Excel's worksheet password protection work
Deleting all the data series in a dynamic chart
Change Background Color for Entire Sheet
Save Excel range as pdf
Excel VBA for selecting an entire column starting from a specific cell
VBA Cut and Paste error
VBA-excel paste chart as a picture
move range of rows down in vba
Excel User Defined Function: change the cell's color
Excel VBA: Type mismatch when passing array
VBA code showing error 2042 for reason unsure
How can i get the Column letters of a cell (need to make it work past the Z column such as AA,AB)
Let property of VBA class modules - is it possible to have multiple arguments?
Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
Pass Argument from VBS to VBA
PowerPoint Text Change Upon Click
Error when calling subroutines "Expected Variable or Procedure, not Module.
Running an Excel Macro via C#: Run a macro from one workbook on another?
VBA for clear value in specific range of cell and protected cell from being wash away formula
Implementing String.Format() in VB6
VBA have a sub run another sub
Is there a Matlab conditional IF operator that can be placed INLINE like VBA's IIF
How to select XML child node using its baseName instead of Item(#)?
VBA Excel, mismatch for inputbox as integer
Cannot execute macro in Break Mode
Excel Macro - Take a snapshot of Particular Range
Date for Previous Monday Excel
AS400 database - Error - PWS9801 - Function rejected by user exit program
VBA MSFORMS vs Controls - whats the difference
Looping through Multi-selected Listbox values to create and name workbook
Connect to web service in MS Access with VBA
VBA:Trigger macro on column filter
What is the difference between Sheets.Select and Sheets.Activate?
Filter table in excel VBA based on a column of values
How to convert the actual excel formula (not the result) to a text string
Trouble with InputBoxes
The data has been changed" error when stepping from main form into sub form
Add x number of days to a date with vba in excel
How to make Excel VBA variables available to multiple macros?
Select column 1 to 10 of ActiveCell row in Excel
How to check which line of VBA code is causing errors
Excel.Worksheet.Cells[row,col] = "=Formula" vs. Range.set_Value(Missing.Value, arrayFormulas)
Read pixel colors of an image
When to use TextFrame or TextFrame2 in VBA
Why is Excel VBA rounding my integer division results?
VBA: Returning A Worksheets Object Reference From A Function
Nested Macros: Scope: how to exit all?
VBA Stop calculation of cells
How to find and replace part of a cell with formatted text
Get current Word document's save directory
How to set calculation mode to manual when opening an excel file?
SQL Server Passthrough query as basis for a DAO recordset in Access
MS Access RunCode Macro cannot find my procedure
VBA hanging on ie.busy and readystate check
How to reduce a huge excel file
No value given for one or more required parameters visual basic error
Refer to QueryTable objects by name
How to write a VBA collection to an Excel sheet
Remove all VBA modules from excel file?
How to optimize vlookup for high search count ? (alternatives to VLOOKUP)
Dictionary in VBA is created with empty key value pair
Ending a macro within a called subroutine
How can I populate textbox through VBA in MS Access?
How to save a Unicode character to a text file
Get values from union of non-contiguous ranges into array with VBA with a simple command (no loops)
Excel VBA: How to obtain a reference to a Shape from the ChartObject
How to use the Implements in Excel VBA
When is it appropriate to explicitly use Err.Clear?
Get item in VBA Collection by Name
How to open a file from an archive in vba without unzipping the archive
How to force VBA editor to enter break mode whenever code is called?
File selector, How do i specify filetype?
How to use comparison methods between class object modules in VBA in a similar manner as VB.NET?
import tab-delimited txt into Access table using VBA
How to disable changes in a cell using vba?
Input past end of file VBA excel
Script to open Access database, run macro, and persist Access instance
Define function that can take null parameter
VBA: Debug.Print without newline?
Pass array to ParamArray
Unable to lookup a date using vba vlookup
Create a new slide in VBA for PowerPoint 2010 with custom layout using Master
VBA RegExp causes Compile error while vbscript.regexp works
Using SQL to query an Excel worksheet without a header row
Can I/How do I show a webpage in an excel form?
Using a InStr function within a Select Case
Excel 2010 VBA Error 1004 with formula
Excel VBA - How do I clear the clipboard on another workbook in another application?
Porting SHA-256 library to Excel
VBA Userforms. Textbox as number value to cell
Turn Off Msg for Update Links for Excel Spreadsheet upon Opening
find last match in column using built in functions in excel
Using a UDF in Excel to update the worksheet
Mod with Doubles
Array already dimensioned - Class module
Excel / VBA: auto-adjust column width after pasting data
Referencing Excel Userform Control Name Value From String (VBA)
Comparing Strings in VBA
VBA difference between public variable and property
How do I click a link on a web page using Excel VBA?
How to run a macro in Word before save?
Fully reference a worksheet by codename
How to append or combine Ranges?
Deep Copy or Clone an ADODB recordset in VBA
Run-time error '3065' Cannot execute a select query
Excel VBA looping through multiple worksheets
VBA Save as PDF with Filename as Cell Value
Difference between declaring a userform as Object vs MSForms.Userform?
Save the cursor position in a document and return there later on
VBA Multiline String Issues
Splitting String With LastIndexOf() in VBA
How to select every table in a Microsoft Word document using VBA Macro
Excel 2013 VBA clear active filter
Splitting String in VBA using RegEx
Creating a "color scale" using vba (avoiding conditional formatting)
Worksheet_Activate not triggering when workbook opened
Access cannot find the referenced form