BYE DESIGN LTD

A Microsoft Windows Mobile Solutions Partner

Electronic mail address: stephenbye@byedesign.co.uk
Copyright Bye Design Ltd 1999-2025. Last revised: May 24, 20245.

VBA Excel Object Model Support

The following items are currently supported.
Details and examples can be found at the Microsoft Excel Object Model web site.

ClassEvent
Workbook
Activate
AfterSave
BeforeClose
BeforePrint
BeforeSave
Deactivate
NewSheet
Open
SheetActivate
SheetBeforeDelete
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetSelectionChange
Worksheet
Activate
BeforeDelete
BeforeDoubleClick
BeforeRightClick
Calculate
Change
Deactivate
FollowHyperlink
SelectionChange
module
Auto_Open

ClassMethod/Property
Application
ActiveCell
ActiveChart
ActiveSheet
ActiveWindow
ActiveWorkbook
Application
AutoFormatAsYouTypeReplaceHyperlinks
Build
Calculate
CalculateFull
CalculateFullRebuild
Calculation
CalculationState
CalculationVersion
Caller
Caption
Cells
CentimetersToPoints
Charts
Columns
ConvertFormula
Creator
CutCopyMode
DefaultFilePath
DefaultSaveFormat
DisplayAlerts
DisplayFormulaBar
DisplayFullScreen
DisplayStatusBar
EditDirectlyInCell
EnableCancelKey
EnableEvents
Evaluate
Excel4MacroSheets
FindFile
GetOpenFileName
GetSaveAsFileName
Goto
Height
Hinstance
HWnd
InchesToPoints
Intersect
Left
MouseAvailable
MoveAfterReturn
MoveAfterReturnDirection
Name
Names
OrganizationName
Parent
Path
PathSeparator
ProductCode
Quit
Range
Ready
RecentFiles
Rows
ScreenUpdating
Selection
SendKeys
Sheets
SheetsInNewWorkbook
StandardFont
StandardFontSize
StatusBar
ThisCell
ThisWorkbook
Top
Undo
UsableHeight
UsableWidth
UserName
Value
Version
Volatile
Wait
Width
Windows
WindowState
Workbooks
WorksheetFunction
Worksheets
AutoFilter
Application
ApplyFilter
Creator
FilterMode
Filters
Parent
Range
ShowAllData
Axes
Application
Count
Creator
Item
Parent
Axis
Application
AxisGroup
AxisTitle
Creator
HasMajorGridlines
HasMinorGridlines
HasTitle
MajorTickMark
MajorUnit
MajorUnitIsAuto
MaximumScale
MaximumScaleIsAuto
MinimumScale
MinimumScaleIsAuto
MinorTickMark
MinorUnit
MinorUnitIsAuto
Parent
ScaleType
Select
TickLabelPosition
TickLabelSpacing
TickMarkSpacing
Type
AxisTitle
Application
Caption
Characters
Creator
Delete
Font
Name
Parent
Select
Text
Border
Application
Color
ColorIndex
Creator
LineStyle
Parent
Weight
Borders
Application
Color
ColorIndex
Count
Creator
Item
LineStyle
Parent
Value
Weight
Characters
Application
Caption
Count
Creator
Delete
Font
Insert
Parent
Text
Chart
Activate
Application
Axes
ChartTitle
ChartType
ChartWizard
CopyPicture
Creator
HasLegend
HasTitle
Name
Next
PageSetup
Parent
Previous
Protect
Select
SeriesCollection
SetSourceData
Tab
Unprotect
Visible
ChartFormat
Application
Creator
Line
Parent
ChartObject
Activate
Application
BottomRightCell
BringToFront
Chart
CopyPicture
Creator
Delete
Duplicate
Height
Left
Name
Parent
Placement
PrintObject
Select
SendToBack
Top
TopLeftCell
Visible
Width
Zorder
ChartObjects
Add
Application
Count
Creator
Delete
Item
Parent
Charts
Add
Application
Count
Creator
Item
Parent
ChartTitle
Application
Caption
Characters
Creator
Delete
Font
Name
Parent
Select
Text
ColorFormat
Application
Creator
Parent
RGB
Comment
Application
Author
Creator
Delete
Next
Parent
Previous
Shape
Text
Comments
Application
Count
Creator
Item
Parent
ConnectorFormat
Application
BeginConnect
BeginConnected
BeginConnectedShape
BeginConnectionSite
BeginDisconnect
Creator
EndConnect
EndConnected
EndConnectedShape
EndConnectionSite
EndDisconnect
Parent
Type
FillFormat
Application
Creator
ForeColor
Parent
Filter
Application
Count
Creator
Criteria1
Criteria2
On
Operator
Parent
Filters
Application
Count
Creator
Item
Parent
Font
Application
Bold
Color
ColorIndex
Creator
FontStyle
Italic
Name
Parent
Size
Strikethrough
Subscript
Superscript
Underline
FormatCondition
Application
AppliesTo
Borders
Creator
Delete
Font
Formula1
Formula2
Interior
Modify
Operator
Parent
Priority
SetFirstPriority
SetLastPriority
Type
FormatConditions
Add
Application
Count
Creator
Delete
Item
Parent
Hyperlink
Address
Application
Creator
Delete
Follow
Name
Parent
Range
SubAddress
TextToDisplay
Hyperlinks
Add
Application
Count
Creator
Delete
Item
Parent
Interior
Application
Color
ColorIndex
Creator
Parent
Pattern
PatternColor
PatternColorIndex
LineFormat
Application
BeginArrowheadStyle
Creator
DashStyle
EndArrowheadStyle
ForeColor
Parent
Style
Visible
Weight
Name
Application
Creator
Delete
Name
Parent
RefersTo
RefersToLocal
RefersToR1C1
RefersToR1C1Local
RefersToRange
ShortcutKey
Value
Visible
Names
Add
Application
Count
Creator
Item
Parent
PageSetup
Application
BlackAndWhite
BottomMargin
CenterFooter
CenterHeader
CenterHorizontally
CenterVertically
Creator
Draft
FirstPageNumber
FitToPagesTall
FitToPagesWide
FooterMargin
HeaderMargin
LeftFooter
LeftHeader
LeftMargin
Order
Orientation
PaperSize
Parent
PrintArea
PrintComments
PrintErrors
PrintGridlines
PrintHeadings
PrintTitleColumns
PrintTitleRows
RightFooter
RightHeader
RightMargin
TopMargin
Zoom
Range
Activate
AddComment
Address
AdvancedFilter
AllowEdit
Application
AutoFilter
AutoFit
BorderAround
Borders
Calculate
CalculateRowMajorOrder
Cells
Characters
Clear
ClearComments
ClearContents
ClearFormats
ClearHyperlinks
Column
Columns
ColumnWidth
Comment
Copy
Count
CountLarge
CreateNames
Creator
CurrentArray
CurrentRegion
Cut
DataSeries
Delete
Dirty
End
EntireColumn
EntireRow
FillDown
FillLeft
FillRight
FillUp
Find
Font
FormatConditions
Formula
FormulaHidden
FormulaLocal
FormulaR1C1
FormulaR1C1Local
HasArray
HasFormula
Height
Hidden
HorizontalAlignment
Hyperlinks
Insert
Interior
Item
Justify
Left
Locked
Merge
MergeArea
MergeCells
Name
Next
NoteText
NumberFormat
Offset
Orientation
Parent
PasteSpecial
PrefixCharacter
Previous
PrintPreview
Range
Replace
Resize
Row
RowHeight
Rows
Select
Show
Sort
SpecialCells
Text
Top
UnMerge
Validation
Value
Value2
VerticalAlignment
Width
Worksheet
WrapText
RecentFile
Application
Creator
Delete
Index
Name
Open
Parent
Path
RecentFiles
Add
Application
Count
Creator
Item
Maximum
Parent
Series
Application
BubbleSizes
Creator
Delete
Fill
Format
HasDataLabels
MarkerBackgroundColor
MarkerBackgroundColorIndex
MarkerForegroundColor
MarkerForegroundColorIndex
MarkerSize
MarkerStyle
Name
Parent
PlotOrder
Select
Values
XValues
SeriesCollection
Application
Count
Creator
Item
NewSeries
Parent
Shape
Application
AutoShapeType
BottomRightCell
Chart
ConnectionSiteCount
Connector
ConnectorFormat
Creator
Delete
Duplicate
Fill
Flip
FormControlType
HasChart
Height
HorizontalFlip
IncrementLeft
IncrementTop
Left
Line
Name
Parent
Placement
RerouteConnections
Select
TextFrame
Top
TopLeftCell
VerticalFlip
Visible
Width
ZOrder
ZOrderPosition
Shapes
AddConnector
AddFormControl
AddLabel
AddLine
AddPicture
AddShape
Application
Count
Creator
Item
Parent
Sheets
Add
Application
Count
Creator
Item
Parent
Sort
Application
Apply
Creator
Header
MatchCase
Orientation
Parent
Rng
SetRange
SortFields
SortField
Application
Creator
Delete
Key
ModifyKey
Order
Parent
Priority
SortFields
Add
Application
Clear
Count
Creator
Item
Parent
Tab
Application
Color
ColorIndex
Creator
Parent
TextFrame
Application
Characters
Creator
HorizontalAlignment
Parent
VerticalAlignment
Validation
Add
AlertStyle
Application
Creator
Delete
ErrorMessage
ErrorTitle
Formula1
Formula2
IgnoreBlank
InCellDropdown
InputMessage
InputTitle
Modify
Operator
Parent
ShowError
ShowInput
Type
Window
Activate
ActivateNext
ActivatePrevious
ActiveCell
ActiveChart
ActiveSheet
Application
Close
Creator
DisplayFormulas
DisplayGridlines
DisplayHeadings
DisplayHorizontalScrollBar
DisplayVerticalScrollBar
DisplayWorkbookTabs
DisplayZeros
FreezePanes
Height
LargeScroll
Left
Parent
PointsToScreenPixelsX
PointsToScreenPixelsY
RangeSelection
ScrollColumn
ScrollRow
Selection
SmallScroll
Top
UsableHeight
UsableWidth
Visible
VisibleRange
Width
WindowNumber
WindowState
Zoom
Windows
Application
Count
Creator
Item
Parent
Workbook
Activate
ActiveChart
ActiveSheet
Application
BuiltinDocumentProperties
CalculationVersion
CaseSensitive
Charts
Close
CodeName
Colors
Creator
Date1904
DeleteNumberFormat
Excel4MacroSheets
FollowHyperlink
FullName
FullNameURLEncoded
HasVBProject
Name
Names
Parent
Path
PrintOut
ResetColors
Save
SaveAs
SaveCopyAs
Saved
Sheets
Unprotect
Windows
Worksheets
Workbooks
Add
Application
Close
Count
Creator
Item
Open
Parent
Worksheet
Activate
Application
AutoFilter
AutoFilterMode
Calculate
Cells
ChartObjects
CodeName
Columns
Comments
Copy
Creator
Delete
FilterMode
Hyperlinks
Index
Move
Name
Names
Next
PageSetup
Parent
Paste
Previous
Protect
ProtectContents
ProtectDrawingObjects
ProtectScenarios
Range
Rows
Shapes
ShowAllData
StandardHeight
StandardWidth
Tab
Type
Unprotect
UsedRange
Visible
Worksheets
Add
Application
Count
Creator
Item
Parent
WorksheetFunction
AccrInt
AccrIntM
Acos
Acosh
Acot
Acoth
Aggregate
AmorDegrc
AmorLinc
Arabic
Asin
Asinh
Atan2
Atanh
AveDev
Average
AverageIf
AverageIfs
BahtText
BesselI
BesselJ
BesselK
BesselY
Beta_Dist
Beta_Inv
BetaDist
BetaInv
Bin2Dec
Bin2Hex
Bin2Oct
Binom_Dist
Binom_Dist_Range
Binom_Inv
BinomDist
Bitand
Bitlshift
Bitor
Bitrshift
Bitxor
Ceiling
Ceiling_Math
Ceiling_Precise
ChiDist
ChiInv
ChiSq_Dist
ChiSq_Dist_RT
ChiSq_Inv
ChiSq_Inv_RT
ChiSq_Test
ChiTest
Clean
Combin
Combina
Complex
Confidence
Confidence_Norm
Confidence_T
Convert
Correl
Cosh
Cot
Coth
CountA
CountBlank
CountIf
CountIfs
CoupDayBs
CoupDays
CoupDaysNc
CoupNcd
CoupNum
CoupPcd
Covar
Covariance_P
Covariance_S
CritBinom
Csc
Csch
CumIPmt
CumPrinc
DAverage
Days
Days360
Db
Dbcs
DCount
DCountA
Dec2Bin
Dec2Hex
Dec2Oct
Degrees
Delta
DevSq
DGet
Disc
DMax
DMin
Dollar
DollarDe
DollarFr
DProduct
DStDev
DStDevP
DSum
Duration
DVar
DVarP
EDate
Effect
EncodeUrl
EoMonth
Erf
Erf_Precise
ErfC
ErfC_Precise
Even
Expon_Dist
ExponDist
F_Dist
F_Dist_RT
F_Inv
F_Inv_RT
F_Test
Fact
FactDouble
FDist
FilterXML
Find
FindB
FInv
Fisher
FisherInv
Fixed
Floor
Floor_Math
Floor_Precise
Forecast
Forecast_ETS
Forecast_ETS_ConfInt
Forecast_ETS_Seasonality
Forecast_ETS_STAT
Forecast_Linear
Frequency
FTest
FVSchedule
Gamma
Gamma_Dist
Gamma_Inv
GammaDist
GammaInv
GammaLn
GammaLn_Precise
Gauss
Gcd
GeoMean
GeStep
Growth
HarMean
Hex2Bin
Hex2Dec
Hex2Oct
HLookup
HypGeom_Dist
HypGeomDist
IfError
IfNa
ImAbs
Imaginary
ImArgument
ImConjugate
ImCos
ImCosh
ImCot
ImCsc
ImCsch
ImDiv
ImExp
ImLn
ImLog10
ImLog2
ImPower
ImProduct
ImReal
ImSec
ImSech
ImSin
ImSinh
ImSqrt
ImSub
ImSum
ImTan
Index
Intercept
IntRate
IsErr
IsEven
IsFormula
IsLogical
IsNA
IsNonText
IsNumber
ISO_Ceiling
IsOdd
IsoWeekNum
Ispmt
IsText
Kurt
Large
Lcm
LinEst
Ln
Log10
LogEst
LogInv
LogNorm_Dist
LogNorm_Inv
LogNormDist
Lookup
Match
Max
MDeterm
MDuration
Median
Min
MInverse
MMult
Mode
Mode_Mult
Mode_Sngl
MRound
MultiNomial
Munit
NegBinom_Dist
NegBinomDist
NetworkDays
NetworkDays_Intl
Nominal
Norm_Dist
Norm_Inv
Norm_S_Dist
Norm_S_Inv
NormDist
NormInv
NormSDist
NormSInv
NumberValue
Oct2Bin
Oct2Dec
Oct2Hex
Odd
OddFPrice
OddFYield
OddLPrice
OddLYield
PDuration
Pearson
Percentile
Percentile_Exc
Percentile_Inc
PercentRank
PercentRank_Exc
PercentRank_Inc
Permut
Permutationa
Phi
Phonetic
Pi
Poisson
Poisson_Dist
Power
Price
PriceDisc
PriceMat
Prob
Product
Proper
Quartile
Quartile_Exc
Quartile_Inc
Quotient
Radians
RandBetween
Rank
Rank_Avg
Rank_Eq
Received
ReplaceB
Rept
Roman
RoundDown
RoundUp
Rri
RSq
Search
SearchB
Sec
Sech
SeriesSum
Sinh
Skew
Skew_p
Slope
Small
SqrtPi
Standardize
StDev
StDev_P
StDev_S
StDevP
StEyx
Substitute
Subtotal
Sum
SumIf
SumIfs
SumProduct
SumSq
SumX2MY2
SumX2PY2
SumXMY2
T_Dist
T_Dist_2T
T_Dist_RT
T_Inv
T_Inv_2T
T_Test
Tanh
TBillEq
TBillPrice
TBillYield
TDist
Text
TInv
Transpose
Trend
TrimMean
TTest
Unichar
Unicode
USDollar
Var
Var_P
Var_S
VarP
Vdb
VLookup
WebService
WeekNum
Weibull
Weibull_Dist
WorkDay
WorkDay_Intl
Xirr
Xnpv
YearFrac
YieldDisc
YieldMat
Z_Test
ZTest
Office.DocumentProperties
Application
Count
Creator
Item
Parent
Office.DocumentProperty
Application
Creator
Name
Parent
Type
Value