VBA Programming


Abbreviated Data Types
Above Average
ABS - Built-in Function
Absolute Recording
Accelerator Keys
Accelerator Property - Userforms
Access Database
Access Keys
Access Read Write
ACRONYM - User Defined Function
ActionControl Property
Actions - Task Pane
ActionsPane
Activate Event
Activate Method - Sheets
Activate Ribbon Tab
Activate Tab on Ribbon
Activating Visual Basic Editor
ActiveCell (Excel)
ActiveChart (Excel)
ActiveDocument (Word)
ActiveDocument.SaveAs (Word)
ActivePresentation (PowerPoint)
ActivePresentation.SaveAs (PowerPoint)
ActiveSheet (Excel)
ActiveWindow.Zoom
ActiveWorkbook (Excel)
ActiveWorkbook.SaveAs (Excel)
ActiveX Automation
ActiveX Controls
ActiveX Data Objects (ADO)
ActiveX Objects
Add Controls to Dialog Box
Add Controls to Userform
Add Record
Add Watch
Add Worksheet (Excel)
AddChart2 - Shapes
AddControl Event
Add-in Manager
Adding a Watch
Adding Class Modules
Adding Code Dynamically
Adding Controls to a Userform
Adding Event Handlers
Adding Functions
Adding Modules
Adding Subroutines
AddinInstall Event
Add-ins - Apps for Office
Add-ins - Bespoke Solutions
Add-ins - C#
Add-ins - Consultancy
Add-ins - Development
Add-ins - Excel
Add-ins - JavaScript
Add-ins - MZ Tools
Add-ins - Office 365 Add-ins
Add-ins - Office.JS
Add-ins - Outlook
Add-ins - PowerPoint
Add-ins - Readiness Toolkit
Add-ins - Rubberduck
Add-ins - Smart Indenter
Add-ins - TypeScript
Add-ins - Visual Basic Editor
Add-ins - Visual Studio
Add-ins - VS Code
Add-ins - VSTO
Add-ins - Web Add-ins
Add-ins - Word
Add-ins > Add-In Manager
AddinUninstall Event
AddItem - Combo Box
AddItem - List Box
Additional Controls
AddPicture
Address R1C1 (Excel)
AddressOf
AddressOf -(Excel)
AddShape
AddTextbox
adLockBatchOptimistic - LockType
adLockOptimistic - LockType
adLockPessimistic - LockType
adLockReadOnly - LockType
ADO - SQL
ADO - Stored Procedure
ADO - Stored Procedure with Parameters
ADO (ActiveX Data Objects)
Adobe
ADODB
ADODB.Command
ADODB.Connection
ADODB.Parameter
ADODB.Recordset
ADODB.Stream
adOpenDynamic - CursorType
adOpenForwardOnly - CursorType
adOpenKeyset - CursorType
adOpenStatic - CursorType
ADOX.Catalog
adUseClient - CursorLocation
adUseServer - CursorLocation
Advanced Filter (Excel)
ADVAPI32.DLL
advapi32.dll
AGE - User Defined Function
Alerts - Application.DisplayAlerts
Alerts - Disable
Alias Keyword
Align Controls to Grid
Aligning Controls
Aligning Userform Controls
All Local Variables as Statics
Alt + F11
Alt Key
AltStartupPath Property
Ambiguous Name Detected - Compile Error
Analysis ToolPak
Analysis ToolPak - VBA Functions
AND - Built-in Operator
AND Operator
ANDALSO Operator (only VB.Net)
AnError - Line Label
ANSI Character Codes
ANSI Character Set
API - 64 Bit
API - advapi32.dll
API - comdlg32.dll (Reference)
API - FindWindowEx
API - gdi32.dll (Reference)
API - GetSystemMetrics
API - kernel32.dll
API - ole32.dll (Reference)
API - RtlMoveMemory
API - shell32.dll
API - SHGetPathFromIDListA
API - user32.dll
API - wininet.dll (Reference)
API - winmm.dll (Reference)
API - winspool.drv (Reference)
API Functions
Apostrophe '
APPACTIVATE - Built-in Statement
Application - Implicit Reference
Application Class
Application Level Events (Excel)
Application Level Events (PowerPoint)
Application Level Events (Word)
Application Programming Interface (API)
Application.ActiveSheet (Excel)
Application.AltStartupPath
Application.AutoRecover.Path
Application.Calculation
Application.Caller
Application.CentimetersToPoints
Application.CommandBars
Application.Commandbars.ExecuteMso
Application.Cursor
Application.DDEExecute
Application.DDETerminate
Application.DefaultFilePath
Application.Dialogs (Excel)
Application.Dialogs (PowerPoint)
Application.Dialogs (Word)
Application.DisplayAlerts
Application.DisplayPageBreaks
Application.DisplayStatusBar
Application.DLast - Access
Application.Documents (Word)
Application.EnableCancelKey
Application.EnableEvents
Application.Evaluate (Excel)
Application.ExecuteExcel4Macro
Application.FileDialog
Application.FileSearch
Application.FindFile
Application.GetOpenFileName
Application.GetSaveAsFileName
Application.Goto (Excel)
Application.Help
Application.hWnd
Application.InchesToPoints
Application.InputBox
Application.Interactive
Application.International
Application.LanguageSettings
Application.LibraryPath
Application.LoadRibbonUI
Application.MacroOptions
Application.Match (Excel)
Application.MenuItems
Application.Name
Application.NetworkTemplatesPath
Application.OnCalculate
Application.OnData
Application.OnEntry
Application.OnKey
Application.OnRepeat
Application.OnSheetActivate
Application.OnSheetDeactivate
Application.OnTime
Application.OnUndo
Application.OnWindow
Application.Path
Application.PointsToInches
Application.ReferencesStyle
Application.RegisterXLL
Application.Run
Application.ScreenUpdating
Application.SendKeys
Application.ShowWindowsInTaskBar
Application.StartupPath
Application.StatusBar
Application.Sum
Application.TemplatesPath
Application.Transpose (Excel)
Application.Union (Excel)
Application.UsableHeight
Application.UsableWidth
Application.UserLibraryPath
Application.Version
Application.Vlookup
Application.Volatile
Application.Wait
Application.WorksheetFunction
Application.WorksheetFunction.Vlookup
Apps For Office
Arbitrary Number of Arguments
Arguments - Evaluated First
Arguments - Named
Arguments - Optional
Arguments - Passed in Parentheses
Arguments - Positional
Arithmetic Operators
Arrange Buttons
ARRAY - Built-in Function
Array Function
Array Size
Array Variables
Array()
Arrays
Arrays - 0 Based
Arrays - 1 Based
Arrays - Adding Items
Arrays - Associated
Arrays - Comparing
Arrays - Converting To Collection
Arrays - Dynamic
Arrays - Empty
Arrays - Erase
Arrays - Exists
Arrays - Finding
Arrays - Fixed
Arrays - Initialising
Arrays - Inserting Items
Arrays - Length
Arrays - Looping
Arrays - Matrices (2 Dim)
Arrays - Multiply
Arrays - Passing In
Arrays - Passing Out
Arrays - ReDim
Arrays - Removing Items
Arrays - Resizing
Arrays - Searching
Arrays - Size
Arrays - Sorting
Arrays - Starting at 0
Arrays - Starting at 1
Arrays - To Keyword
Arrays - Transposing
Arrays - Vectors
As Application
As Byte
As Currency
As Double
As Excel.Range
As Integer
As Keyword
As Long
As LongLong
As LongPtr
As Range
As Single
As String
As Variant
ASC - Built-in Function
ASCII Character Set
ASCII Codes
ASCII String Codes
Ask User to Provide Information
Assert - Debug.Assert
Assertions
Assign Macro Dialog Box
Assigning Macros
Assigning Numbers to Variables
Assigning Strings to Variables
Assigning Values to Variables
Assignment Expressions
Assignment Operator
Assignment Statements
Associated Array - Hash Table
Asterisk Operator *
ASYCFILT.dll
ATN - Built-in Function
ATPVBEAN.xlam
Attributes - VB_Creatable
Attributes - VB_Exposed
Attributes - VB_GlobalNameSpace
Attributes - VB_Name
Attributes - VB_PredeclaredId
Attributes - VBE
Auto Complete
Auto Data Tips
Auto Indent
Auto List Members
Auto Macros
Auto Quick Info
Auto Syntax Check
Auto Update Macro
Auto_Close
Auto_Open
AutoClose
AutoComplete Combo Box
AutoComplete Drop-Down
AutoExec
AutoExit
Auto-Instancing Object Variables
Automate Tab - Ribbon
Automatic Case Correction
Automatic Completion
Automatic Events
Automatic Formatting
Automation Add-ins
Automation Object
Automation Testing - Selenium
AutoNew
AutoOpen
Available Space Property
AVERAGEIFSVISIBLE - User Defined Function
AVERAGETOP - User Defined Function
Avoiding Naming Conflicts
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Updated: 01 June 2021 01 Jun 2021