VBA Programming Help and SupportVBA Programming


Abbreviated Data Types
ABS - Built-in Function
Absolute Recording
Accelerator Keys
Accelerator Property - Userforms
Access Database
Access Keys
Access Modifiers
Access Modifiers - Friend
Access Modifiers - Global
Access Modifiers - Private
Access Modifiers - Public
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 (Excel)
ActiveWindow (PowerPoint)*
ActiveWindow (Word)
ActiveWindow.Caption (Word)
ActiveWindow.Zoom (Word)
ActiveWorkbook (Excel)
ActiveWorkbook.SaveAs (Excel)
ActiveX Automation
ActiveX Controls - Excel Worksheets
ActiveX Data Objects (ADO)
ActiveX Objects
Add Controls to Dialog Box
Add Controls to Userform
Add Digits
Add Record (ADO)
Add Watch
Add Worksheet (Excel)
AddChart
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 - AutoMacro
Add-ins - Bespoke Solutions
Add-ins - C#
Add-ins - COM
Add-ins - Consultancy
Add-ins - Development
Add-ins - Excel
Add-ins - Excel Custom Functions
Add-ins - Excel DNA
Add-ins - Excel Financial Modelling
Add-ins - JavaScript*
Add-ins - MZ Tools
Add-ins - Office 365*
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
AddPicture2
Address R1C1 (Excel)
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
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 - 32 Bit
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 - vbscript.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.LoadCustomUI - Access
Application.MacroOptions
Application.Match (Excel)
Application.MenuItems
Application.MultiThreadedCalculation
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.UserName
Application.Version
Application.Vlookup
Application.Volatile
Application.Wait
Application.WorksheetFunction
Application.WorksheetFunction.Sum
Application.WorksheetFunction.Vlookup
Application_SheetChange
Apps For Office*
Arbitrary Number of Arguments
Arguments - Default Values
Arguments - Evaluated First
Arguments - Named
Arguments - Optional
Arguments - Passed in Parentheses
Arguments - Positional
Arguments vs Parameters
Arithmetic Operators
Arrange Buttons
ARRAY - Built-in Function
Array Function
Array Size
Array Variables
Array()
ArrayList - User Defined
ArrayList Data Structure
Arrays
Arrays - 0 Based
Arrays - 1 Based
Arrays - Accessing Items
Arrays - Adding Items
Arrays - Associated
Arrays - Clearing
Arrays - Combining
Arrays - Comparing
Arrays - Converting to Collection
Arrays - Converting to Dictionary
Arrays - Converting to Text
Arrays - Copying
Arrays - Declaring
Arrays - Deleting Items
Arrays - Dynamic
Arrays - Empty
Arrays - Erase
Arrays - Exists
Arrays - Finding Items
Arrays - Fixed
Arrays - Initialising
Arrays - Inserting Items
Arrays - Length
Arrays - Looping
Arrays - Matrices (2 Dim)
Arrays - Multiplying
Arrays - Passing In
Arrays - Passing Out
Arrays - Questions
Arrays - ReDim
Arrays - Removing Items
Arrays - Replacing Items
Arrays - Resizing
Arrays - Searching
Arrays - Size
Arrays - Sorting
Arrays - Starting at 0
Arrays - Starting at 1
Arrays - Static
Arrays - To Keyword
Arrays - Transposing
Arrays - Updating Items
Arrays - Variant Data Type
Arrays - Vectors
As Application
As Byte
As Control
As Currency
As Double
As Excel.Range (Excel)
As Integer
As Keyword
As Long
As LongLong
As LongPtr
As MSForms.ComboBox
As Range (Excel)
As Single
As String
As Variant
ASC - Built-in Function
ASCII Character Set
ASCII Codes
ASCII String Codes
ASCW - Built-in Function
Ask User to Provide Information
Assert - Debug.Assert
Assert Statement - 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_Description
Attributes - VB_Exposed
Attributes - VB_GlobalNameSpace
Attributes - VB_Name
Attributes - VB_PredeclaredId
Attributes - VB_UserMemId
Attributes - VB_VarUserMemId
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
AutoFilter (Excel)
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
Average Only Visible Cells
AVERAGEIFSVISIBLE - User Defined Function
AVERAGETOP - User Defined Function
Avoiding Naming Conflicts
 
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Updated: 01 March 2024 01 March 2024