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.
Class | Event |
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 |
Class | Method/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 |