I use SCite4AutoHotkey as my main text editor for AHK. I like how it has a built in Intellisense to help remember function and command parameters, etc.
I'm wondering if there is a way to make custom add-ons to this or if you know a way to make this without SCite4AutoHotkey? I have an excel table that I made from the Excel MSDN Object Model docs, and would love if I could see my options when coding as I make paths to different objects within Excel.
I searched around a bit but couldn't seem to find a solution. Is this something I could use ToolTip for?
An example would be:
I type "Range."
Then would get a dropdown list like in SCite4AutoHotkey for all the Methods and Properties.
Then let's say I type "Cop", then the dropdown list would filter anything out that doesn't contain "cop" in it, in this case I would be left with 3 Range Methods to choose from:
Copy
CopyFromRecordset
CopyPicture
I can either press tab to select the top option, or click the option with my mouse and it will finish spelling the word.
I would imagine something like this is already out there, but had no luck finding it. I'd like to build this out for Excel COM and likely other similar things I may encounter.
Thanks a bunch for your help in advance! Happy New Year
Here is a snippet of the Excel array I am dealing with, happy to make it into other forms if necessary for this project.
Code: Select all
Object Object Children Function
AboveAverage object Methods Delete
AboveAverage object Methods ModifyAppliesToRange
AboveAverage object Methods SetFirstPriority
AboveAverage object Methods SetLastPriority
AboveAverage object Properties AboveBelow
AboveAverage object Properties Application
AboveAverage object Properties AppliesTo
AboveAverage object Properties Borders
AboveAverage object Properties CalcFor
AboveAverage object Properties Creator
AboveAverage object Properties Font
AboveAverage object Properties Interior
AboveAverage object Properties NumberFormat
AboveAverage object Properties NumStdDev
AboveAverage object Properties Parent
AboveAverage object Properties Priority
AboveAverage object Properties PTCondition
AboveAverage object Properties ScopeType
AboveAverage object Properties StopIfTrue
AboveAverage object Properties Type
Action object Methods Execute
Action object Properties Application
Action object Properties Caption
Action object Properties Content
Action object Properties Coordinate
Action object Properties Creator
Action object Properties Name
Action object Properties Parent
Action object Properties Type
Actions object Properties Application
Actions object Properties Count
Actions object Properties Creator
Actions object Properties Item
Actions object Properties Parent
AddIn object Properties Application
AddIn object Properties CLSID
AddIn object Properties Creator
AddIn object Properties FullName
AddIn object Properties Installed
AddIn object Properties IsOpen
AddIn object Properties Name
AddIn object Properties Parent
AddIn object Properties Path
AddIn object Properties progID
AddIns object Methods Add
AddIns object Properties Application
AddIns object Properties Count
AddIns object Properties Creator
AddIns object Properties Item
AddIns object Properties Parent
AddIns2 object Methods Add
AddIns2 object Properties Application
AddIns2 object Properties Count
AddIns2 object Properties Creator
AddIns2 object Properties Item
AddIns2 object Properties Parent
Adjustments object Properties Application
Adjustments object Properties Count
Adjustments object Properties Creator
Adjustments object Properties Item
Adjustments object Properties Parent
AllowEditRange object Methods ChangePassword
AllowEditRange object Methods Delete
AllowEditRange object Methods Unprotect
AllowEditRange object Properties Range
AllowEditRange object Properties Title
AllowEditRange object Properties Users
AllowEditRanges object Methods Add
AllowEditRanges object Properties Count
AllowEditRanges object Properties Item
Application object Events AfterCalculate
Application object Events NewWorkbook
Application object Events ProtectedViewWindowActivate
Application object Events ProtectedViewWindowBeforeClose
Application object Events ProtectedViewWindowBeforeEdit
Application object Events ProtectedViewWindowDeactivate
Application object Events ProtectedViewWindowOpen
Application object Events ProtectedViewWindowResize
Application object Events SheetActivate
Application object Events SheetBeforeDelete
Application object Events SheetBeforeDoubleClick
Application object Events SheetBeforeRightClick
Application object Events SheetCalculate
Application object Events SheetChange
Application object Events SheetDeactivate
Application object Events SheetFollowHyperlink
Application object Events SheetLensGalleryRenderComplete
Application object Events SheetPivotTableAfterValueChange
Application object Events SheetPivotTableBeforeAllocateChanges
Application object Events SheetPivotTableBeforeCommitChanges
Application object Events SheetPivotTableBeforeDiscardChanges
Application object Events SheetPivotTableUpdate
Application object Events SheetSelectionChange
Application object Events SheetTableUpdate
Application object Events WindowActivate
Application object Events WindowDeactivate
Application object Events WindowResize
Application object Events WorkbookActivate
Application object Events WorkbookAddinInstall
Application object Events WorkbookAddinUninstall
Application object Events WorkbookAfterRemoteChange
Application object Events WorkbookAfterSave
Application object Events WorkbookAfterXmlExport
Application object Events WorkbookAfterXmlImport
Application object Events WorkbookBeforeClose
Application object Events WorkbookBeforePrint
Application object Events WorkbookBeforeRemoteChange
Application object Events WorkbookBeforeSave
Application object Events WorkbookBeforeXmlExport
Application object Events WorkbookBeforeXmlImport
Application object Events WorkbookDeactivate
Application object Events WorkbookModelChange
Application object Events WorkbookNewChart
Application object Events WorkbookNewSheet
Application object Events WorkbookOpen
Application object Events WorkbookPivotTableCloseConnection
Application object Events WorkbookPivotTableOpenConnection
Application object Events WorkbookRowsetComplete
Application object Events WorkbookSync
Application object Methods ActivateMicrosoftApp
Application object Methods AddCustomList
Application object Methods Calculate
Application object Methods CalculateFull
Application object Methods CalculateFullRebuild
Application object Methods CalculateUntilAsyncQueriesDone
Application object Methods CentimetersToPoints
Application object Methods CheckAbort
Application object Methods CheckSpelling
Application object Methods ConvertFormula
Application object Methods DDEExecute
Application object Methods DDEInitiate
Application object Methods DDEPoke
Application object Methods DDERequest
Application object Methods DDETerminate
Application object Methods DeleteCustomList
Application object Methods DisplayXMLSourcePane
Application object Methods DoubleClick
Application object Methods Evaluate
Application object Methods ExecuteExcel4Macro
Application object Methods FindFile
Application object Methods GetCustomListContents
Application object Methods GetCustomListNum
Application object Methods GetOpenFilename
Application object Methods GetPhonetic
Application object Methods GetSaveAsFilename
Application object Methods Goto
Application object Methods Help
Application object Methods InchesToPoints
Application object Methods InputBox
Application object Methods Intersect
Application object Methods MacroOptions
Application object Methods MailLogoff
Application object Methods MailLogon
Application object Methods NextLetter
Application object Methods OnKey
Application object Methods OnRepeat
Application object Methods OnTime
Application object Methods OnUndo
Application object Methods Quit
Application object Methods RecordMacro
Application object Methods RegisterXLL
Application object Methods Repeat
Application object Methods Run
Application object Methods SaveWorkspace
Application object Methods SendKeys
Application object Methods SharePointVersion
Application object Methods Undo
Application object Methods Union
Application object Methods Volatile
Application object Methods Wait
Application object Properties ActiveCell
Application object Properties ActiveChart
Application object Properties ActiveEncryptionSession
Application object Properties ActivePrinter
Application object Properties ActiveProtectedViewWindow
Application object Properties ActiveSheet
Application object Properties ActiveWindow
Application object Properties ActiveWorkbook
Application object Properties AddIns
Application object Properties AddIns2
Application object Properties AlertBeforeOverwriting
Application object Properties AltStartupPath
Application object Properties AlwaysUseClearType
Application object Properties Application
Application object Properties ArbitraryXMLSupportAvailable
Application object Properties AskToUpdateLinks
Application object Properties Assistance
Application object Properties AutoCorrect
Application object Properties AutoFormatAsYouTypeReplaceHyperlinks
Application object Properties AutomationSecurity
Application object Properties AutoPercentEntry
Application object Properties AutoRecover
Application object Properties Build
Application object Properties CalculateBeforeSave
Application object Properties Calculation
Application object Properties CalculationInterruptKey
Application object Properties CalculationState
Application object Properties CalculationVersion
Application object Properties Caller
Application object Properties CanPlaySounds
Application object Properties CanRecordSounds
Application object Properties Caption
Application object Properties CellDragAndDrop
Application object Properties Cells
Application object Properties ChartDataPointTrack
Application object Properties Charts
Application object Properties ClipboardFormats
Application object Properties ClusterConnector
Application object Properties Columns
Application object Properties COMAddIns
Application object Properties CommandBars
Application object Properties CommandUnderlines
Application object Properties ConstrainNumeric
Application object Properties ControlCharacters
Application object Properties CopyObjectsWithCells
Application object Properties Creator
Application object Properties Cursor
Application object Properties CursorMovement
Application object Properties CustomListCount
Application object Properties CutCopyMode
Application object Properties DataEntryMode
Application object Properties DDEAppReturnCode
Application object Properties DecimalSeparator
Application object Properties DefaultFilePath
Application object Properties DefaultSaveFormat
Application object Properties DefaultSheetDirection
Application object Properties DefaultWebOptions
Application object Properties DeferAsyncQueries
Application object Properties Dialogs
Application object Properties DisplayAlerts
Application object Properties DisplayClipboardWindow
Application object Properties DisplayCommentIndicator
Application object Properties DisplayDocumentActionTaskPane
Application object Properties DisplayDocumentInformationPanel
Application object Properties DisplayExcel4Menus
Application object Properties DisplayFormulaAutoComplete
Application object Properties DisplayFormulaBar
Application object Properties DisplayFullScreen
Application object Properties DisplayFunctionToolTips
Application object Properties DisplayInsertOptions
Application object Properties DisplayNoteIndicator
Application object Properties DisplayPasteOptions
Application object Properties DisplayRecentFiles
Application object Properties DisplayScrollBars
Application object Properties DisplayStatusBar
Application object Properties EditDirectlyInCell
Application object Properties EnableAnimations
Application object Properties EnableAutoComplete
Application object Properties EnableCancelKey
Application object Properties EnableCheckFileExtensions
Application object Properties EnableEvents
Application object Properties EnableLargeOperationAlert
Application object Properties EnableLivePreview
Application object Properties EnableMacroAnimations
Application object Properties EnableSound
Application object Properties ErrorCheckingOptions
Application object Properties Excel4IntlMacroSheets
Application object Properties Excel4MacroSheets
Application object Properties ExtendList
Application object Properties FeatureInstall
Application object Properties FileConverters
Application object Properties FileDialog
Application object Properties FileExportConverters
Application object Properties FileValidation
Application object Properties FileValidationPivot
Application object Properties FindFormat
Application object Properties FixedDecimal
Application object Properties FixedDecimalPlaces
Application object Properties FlashFill
Application object Properties FlashFillMode
Application object Properties FormulaBarHeight
Application object Properties GenerateGetPivotData
Application object Properties GenerateTableRefs
Application object Properties Height
Application object Properties HighQualityModeForGraphics
Application object Properties Hinstance
Application object Properties HinstancePtr
Application object Properties Hwnd
Application object Properties IgnoreRemoteRequests
Application object Properties Interactive
Application object Properties International
Application object Properties IsSandboxed
Application object Properties Iteration
Application object Properties LanguageSettings
Application object Properties LargeOperationCellThousandCount
Application object Properties Left
Application object Properties LibraryPath
Application object Properties MailSession
Application object Properties MailSystem
Application object Properties MapPaperSize
Application object Properties MathCoprocessorAvailable
Application object Properties MaxChange
Application object Properties MaxIterations
Application object Properties MeasurementUnit
Application object Properties MergeInstances
Application object Properties MouseAvailable
Application object Properties MoveAfterReturn
Application object Properties MoveAfterReturnDirection
Application object Properties MultiThreadedCalculation
Application object Properties Name
Application object Properties Names
Application object Properties NetworkTemplatesPath
Application object Properties NewWorkbook
Application object Properties ODBCErrors
Application object Properties ODBCTimeout
Application object Properties OLEDBErrors
Application object Properties OnWindow
Application object Properties OperatingSystem
Application object Properties OrganizationName
Application object Properties Parent
Application object Properties Path
Application object Properties PathSeparator
Application object Properties PivotTableSelection
Application object Properties PreviousSelections
Application object Properties PrintCommunication
Application object Properties ProductCode
Application object Properties PromptForSummaryInfo
Application object Properties ProtectedViewWindows
Application object Properties QuickAnalysis
Application object Properties Range
Application object Properties Ready
Application object Properties RecentFiles
Application object Properties RecordRelative
Application object Properties ReferenceStyle
Application object Properties RegisteredFunctions
Application object Properties ReplaceFormat
Application object Properties RollZoom
Application object Properties Rows
Application object Properties RTD
Application object Properties ScreenUpdating
Application object Properties Selection
Application object Properties Sheets
Application object Properties SheetsInNewWorkbook
Application object Properties ShowChartTipNames
Application object Properties ShowChartTipValues
Application object Properties ShowDevTools
Application object Properties ShowMenuFloaties
Application object Properties ShowQuickAnalysis
Application object Properties ShowSelectionFloaties
Application object Properties ShowStartupDialog
Application object Properties ShowToolTips
Application object Properties SmartArtColors
Application object Properties SmartArtLayouts
Application object Properties SmartArtQuickStyles
Application object Properties Speech
Application object Properties SpellingOptions
Application object Properties StandardFont
Application object Properties StandardFontSize
Application object Properties StartupPath
Application object Properties StatusBar
Application object Properties TemplatesPath
Application object Properties ThisCell
Application object Properties ThisWorkbook
Application object Properties ThousandsSeparator
Application object Properties Top
Application object Properties TransitionMenuKey
Application object Properties TransitionMenuKeyAction
Application object Properties TransitionNavigKeys
Application object Properties UsableHeight
Application object Properties UsableWidth
Application object Properties UseClusterConnector
Application object Properties UsedObjects
Application object Properties UserControl
Application object Properties UserLibraryPath
Application object Properties UserName
Application object Properties UseSystemSeparators
Application object Properties Value
Application object Properties VBE
Application object Properties Version
Application object Properties Visible
Application object Properties WarnOnFunctionNameConflict
Application object Properties Watches
Application object Properties Width
Application object Properties Windows
Application object Properties WindowsForPens
Application object Properties WindowState
Application object Properties Workbooks
Application object Properties WorksheetFunction
Application object Properties Worksheets
Areas object Properties Application
Areas object Properties Count
Areas object Properties Creator
Areas object Properties Item
Areas object Properties Parent
AutoCorrect object Methods AddReplacement
AutoCorrect object Methods DeleteReplacement
AutoCorrect object Properties Application
AutoCorrect object Properties AutoExpandListRange
AutoCorrect object Properties AutoFillFormulasInLists
AutoCorrect object Properties CapitalizeNamesOfDays
AutoCorrect object Properties CorrectCapsLock
AutoCorrect object Properties CorrectSentenceCap
AutoCorrect object Properties Creator
AutoCorrect object Properties DisplayAutoCorrectOptions
AutoCorrect object Properties Parent
AutoCorrect object Properties ReplacementList
AutoCorrect object Properties ReplaceText
AutoCorrect object Properties TwoInitialCapitals
AutoFilter object Methods ApplyFilter
AutoFilter object Methods ShowAllData
AutoFilter object Properties Application
AutoFilter object Properties Creator
AutoFilter object Properties FilterMode
AutoFilter object Properties Filters
AutoFilter object Properties Parent
AutoFilter object Properties Range
AutoFilter object Properties Sort
AutoRecover object Properties Application
AutoRecover object Properties Creator
AutoRecover object Properties Enabled
AutoRecover object Properties Parent
AutoRecover object Properties Path
AutoRecover object Properties Time
Axes object Methods Item
Axes object Properties Application
Axes object Properties Count
Axes object Properties Creator
Axes object Properties Parent
Axis object Methods Delete
Axis object Methods Select
Axis object Properties Application
Axis object Properties AxisBetweenCategories
Axis object Properties AxisGroup
Axis object Properties AxisTitle
Axis object Properties BaseUnit
Axis object Properties BaseUnitIsAuto
Axis object Properties Border
Axis object Properties CategoryNames
Axis object Properties CategoryType
Axis object Properties Creator
Axis object Properties Crosses
Axis object Properties CrossesAt
Axis object Properties DisplayUnit
Axis object Properties DisplayUnitCustom
Axis object Properties DisplayUnitLabel
Axis object Properties Format
Axis object Properties HasDisplayUnitLabel
Axis object Properties HasMajorGridlines
Axis object Properties HasMinorGridlines
Axis object Properties HasTitle
Axis object Properties Height
Axis object Properties Left
Axis object Properties LogBase
Axis object Properties MajorGridlines
Axis object Properties MajorTickMark
Axis object Properties MajorUnit
Axis object Properties MajorUnitIsAuto
Axis object Properties MajorUnitScale
Axis object Properties MaximumScale
Axis object Properties MaximumScaleIsAuto
Axis object Properties MinimumScale
Axis object Properties MinimumScaleIsAuto
Axis object Properties MinorGridlines
Axis object Properties MinorTickMark
Axis object Properties MinorUnit
Axis object Properties MinorUnitIsAuto
Axis object Properties MinorUnitScale
Axis object Properties Parent
Axis object Properties ReversePlotOrder
Axis object Properties ScaleType
Axis object Properties TickLabelPosition
Axis object Properties TickLabels
Axis object Properties TickLabelSpacing
Axis object Properties TickLabelSpacingIsAuto
Axis object Properties TickMarkSpacing
Axis object Properties Top
Axis object Properties Type
Axis object Properties Width
AxisTitle object Methods Delete
AxisTitle object Methods Select
AxisTitle object Properties Application
AxisTitle object Properties Caption
AxisTitle object Properties Characters
AxisTitle object Properties Creator
AxisTitle object Properties Format
AxisTitle object Properties Formula
AxisTitle object Properties FormulaLocal
AxisTitle object Properties FormulaR1C1
AxisTitle object Properties FormulaR1C1Local
AxisTitle object Properties Height
AxisTitle object Properties HorizontalAlignment
AxisTitle object Properties IncludeInLayout
AxisTitle object Properties Left
AxisTitle object Properties Name
AxisTitle object Properties Orientation
AxisTitle object Properties Parent
AxisTitle object Properties Position
AxisTitle object Properties ReadingOrder
AxisTitle object Properties Shadow
AxisTitle object Properties Text
AxisTitle object Properties Top
AxisTitle object Properties VerticalAlignment
AxisTitle object Properties Width
Border object Properties Application
Border object Properties Color
Border object Properties ColorIndex
Border object Properties Creator
Border object Properties LineStyle
Border object Properties Parent
Border object Properties ThemeColor
Border object Properties TintAndShade
Border object Properties Weight
Borders object Properties Application
Borders object Properties Color
Borders object Properties ColorIndex
Borders object Properties Count
Borders object Properties Creator
Borders object Properties Item
Borders object Properties LineStyle
Borders object Properties Parent
Borders object Properties ThemeColor
Borders object Properties TintAndShade
Borders object Properties Value
Borders object Properties Weight
CalculatedFields object Methods Add
CalculatedFields object Methods Item
CalculatedFields object Properties Application
CalculatedFields object Properties Count
CalculatedFields object Properties Creator
CalculatedFields object Properties Parent
CalculatedItems object Methods Add
CalculatedItems object Methods Item
CalculatedItems object Properties Application
CalculatedItems object Properties Count
CalculatedItems object Properties Creator
CalculatedItems object Properties Parent
CalculatedMembers object Methods Add
CalculatedMembers object Methods AddCalculatedMember
CalculatedMembers object Properties Application
CalculatedMembers object Properties Count
CalculatedMembers object Properties Creator
CalculatedMembers object Properties Item
CalculatedMembers object Properties Parent
CalloutFormat object Methods AutomaticLength
CalloutFormat object Methods CustomDrop
CalloutFormat object Methods CustomLength
CalloutFormat object Methods PresetDrop
CalloutFormat object Properties Accent
CalloutFormat object Properties Angle
CalloutFormat object Properties Application
CalloutFormat object Properties AutoAttach
CalloutFormat object Properties AutoLength
CalloutFormat object Properties Border
CalloutFormat object Properties Creator
CalloutFormat object Properties Drop
CalloutFormat object Properties DropType
CalloutFormat object Properties Gap
CalloutFormat object Properties Length
CalloutFormat object Properties Parent
CalloutFormat object Properties Type
CategoryCollection object Methods Item
CategoryCollection object Properties Application
CategoryCollection object Properties Count
CategoryCollection object Properties Creator
CategoryCollection object Properties Parent
CellFormat object Methods Clear
CellFormat object Properties AddIndent
CellFormat object Properties Application
CellFormat object Properties Borders
CellFormat object Properties Creator
CellFormat object Properties Font
CellFormat object Properties FormulaHidden
CellFormat object Properties HorizontalAlignment
CellFormat object Properties IndentLevel
CellFormat object Properties Interior
CellFormat object Properties Locked
CellFormat object Properties MergeCells
CellFormat object Properties NumberFormat
CellFormat object Properties NumberFormatLocal
CellFormat object Properties Orientation
CellFormat object Properties Parent
CellFormat object Properties ShrinkToFit
CellFormat object Properties VerticalAlignment
CellFormat object Properties WrapText
Characters object Methods Delete
Characters object Methods Insert
Characters object Properties Application
Characters object Properties Caption
Characters object Properties Count
Characters object Properties Creator
Characters object Properties Font
Characters object Properties Parent
Characters object Properties PhoneticCharacters
Characters object Properties Text
Chart object Events Activate
Chart object Events BeforeDoubleClick
Chart object Events BeforeRightClick
Chart object Events Calculate
Chart object Events Deactivate
Chart object Events MouseDown
Chart object Events MouseMove
Chart object Events MouseUp
Chart object Events Resize
Chart object Events Select
Chart object Events SeriesChange
Chart object Methods Activate
Chart object Methods ApplyChartTemplate
Chart object Methods ApplyDataLabels
Chart object Methods ApplyLayout
Chart object Methods Axes
Chart object Methods ChartGroups
Chart object Methods ChartObjects
Chart object Methods ChartWizard
Chart object Methods CheckSpelling
Chart object Methods ClearToMatchColorStyle
Chart object Methods ClearToMatchStyle
Chart object Methods Copy
Chart object Methods CopyPicture
Chart object Methods Delete
Chart object Methods Evaluate
Chart object Methods Export
Chart object Methods ExportAsFixedFormat
Chart object Methods FullSeriesCollection
Chart object Methods GetChartElement
Chart object Methods Location
Chart object Methods Move
Chart object Methods OLEObjects
Chart object Methods Paste
Chart object Methods PrintOut
Chart object Methods PrintPreview
Chart object Methods Protect
Chart object Methods Refresh
Chart object Methods SaveAs
Chart object Methods SaveChartTemplate
Chart object Methods Select
Chart object Methods SeriesCollection
Chart object Methods SetBackgroundPicture
Chart object Methods SetDefaultChart
Chart object Methods SetElement
Chart object Methods SetSourceData
Chart object Methods Unprotect
Chart object Properties Application
Chart object Properties AutoScaling
Chart object Properties BackWall
Chart object Properties BarShape
Chart object Properties CategoryLabelLevel
Chart object Properties ChartArea
Chart object Properties ChartColor
Chart object Properties ChartStyle
Chart object Properties ChartTitle
Chart object Properties ChartType
Chart object Properties CodeName
Chart object Properties Creator
Chart object Properties DataTable
Chart object Properties DepthPercent
Chart object Properties DisplayBlanksAs
Chart object Properties Elevation
Chart object Properties Floor
Chart object Properties GapDepth
Chart object Properties HasAxis
Chart object Properties HasDataTable
Chart object Properties HasLegend
Chart object Properties HasTitle
Chart object Properties HeightPercent
Chart object Properties Hyperlinks
Chart object Properties Index
Chart object Properties Legend
Chart object Properties MailEnvelope
Chart object Properties Name
Chart object Properties Next
Chart object Properties PageSetup
Chart object Properties Parent
Chart object Properties Perspective
Chart object Properties PivotLayout
Chart object Properties PlotArea
Chart object Properties PlotBy
Chart object Properties PlotVisibleOnly
Chart object Properties Previous
Chart object Properties PrintedCommentPages
Chart object Properties ProtectContents
Chart object Properties ProtectData
Chart object Properties ProtectDrawingObjects
Chart object Properties ProtectFormatting
Chart object Properties ProtectionMode
Chart object Properties ProtectSelection
Chart object Properties RightAngleAxes
Chart object Properties Rotation
Chart object Properties SeriesNameLevel
Chart object Properties Shapes
Chart object Properties ShowAllFieldButtons
Chart object Properties ShowAxisFieldButtons
Chart object Properties ShowDataLabelsOverMaximum
Chart object Properties ShowExpandCollapseEntireFieldButtons
Chart object Properties ShowLegendFieldButtons
Chart object Properties ShowReportFilterFieldButtons
Chart object Properties ShowValueFieldButtons
Chart object Properties SideWall
Chart object Properties Tab
Chart object Properties Visible
Chart object Properties Walls
ChartArea object Methods Clear
ChartArea object Methods ClearContents
ChartArea object Methods ClearFormats
ChartArea object Methods Copy
ChartArea object Methods Select
ChartArea object Properties Application
ChartArea object Properties Creator
ChartArea object Properties Format
ChartArea object Properties Height
ChartArea object Properties Left
ChartArea object Properties Name
ChartArea object Properties Parent
ChartArea object Properties RoundedCorners
ChartArea object Properties Shadow
ChartArea object Properties Top
ChartArea object Properties Width
ChartCategory object Properties Application
ChartCategory object Properties Creator
ChartCategory object Properties IsFiltered
ChartCategory object Properties Name
ChartCategory object Properties Parent
ChartFormat object Properties Adjustments
ChartFormat object Properties Application
ChartFormat object Properties AutoShapeType
ChartFormat object Properties Creator
ChartFormat object Properties Fill
ChartFormat object Properties Glow
ChartFormat object Properties Line
ChartFormat object Properties Parent
ChartFormat object Properties PictureFormat
ChartFormat object Properties Shadow
ChartFormat object Properties SoftEdge
ChartFormat object Properties TextFrame2
ChartFormat object Properties ThreeD
ChartGroup object Methods CategoryCollection
ChartGroup object Methods FullCategoryCollection
ChartGroup object Methods SeriesCollection
ChartGroup object Properties Application
ChartGroup object Properties AxisGroup
ChartGroup object Properties BinsCountValue
ChartGroup object Properties BinsOverflowEnabled
ChartGroup object Properties BinsOverflowValue
ChartGroup object Properties BinsType
ChartGroup object Properties BinsUnderflowEnabled
ChartGroup object Properties BinsUnderflowValue
ChartGroup object Properties BinWidthValue
ChartGroup object Properties BubbleScale
ChartGroup object Properties Creator
ChartGroup object Properties DoughnutHoleSize
ChartGroup object Properties DownBars
ChartGroup object Properties DropLines
ChartGroup object Properties FirstSliceAngle
ChartGroup object Properties GapWidth
ChartGroup object Properties Has3DShading
ChartGroup object Properties HasDropLines
ChartGroup object Properties HasHiLoLines
ChartGroup object Properties HasRadarAxisLabels
ChartGroup object Properties HasSeriesLines
ChartGroup object Properties HasUpDownBars
ChartGroup object Properties HiLoLines
ChartGroup object Properties Index
ChartGroup object Properties Overlap
ChartGroup object Properties Parent
ChartGroup object Properties RadarAxisLabels
ChartGroup object Properties SecondPlotSize
ChartGroup object Properties SeriesLines
ChartGroup object Properties ShowNegativeBubbles
ChartGroup object Properties SizeRepresents
ChartGroup object Properties SplitType
ChartGroup object Properties SplitValue
ChartGroup object Properties UpBars
ChartGroup object Properties VaryByCategories
ChartGroups object Methods Item
ChartGroups object Properties Application
ChartGroups object Properties Count
ChartGroups object Properties Creator
ChartGroups object Properties Parent
ChartObject object Methods Activate
ChartObject object Methods BringToFront
ChartObject object Methods Copy
ChartObject object Methods CopyPicture
ChartObject object Methods Cut
ChartObject object Methods Delete
ChartObject object Methods Duplicate
ChartObject object Methods Select
ChartObject object Methods SendToBack
ChartObject object Properties Application
ChartObject object Properties BottomRightCell
ChartObject object Properties Chart
ChartObject object Properties Creator
ChartObject object Properties Height
ChartObject object Properties Index
ChartObject object Properties Left
ChartObject object Properties Locked
ChartObject object Properties Name
ChartObject object Properties Parent
ChartObject object Properties Placement
ChartObject object Properties PrintObject
ChartObject object Properties ProtectChartObject
ChartObject object Properties RoundedCorners
ChartObject object Properties Shadow
ChartObject object Properties ShapeRange
ChartObject object Properties Top
ChartObject object Properties TopLeftCell
ChartObject object Properties Visible
ChartObject object Properties Width
ChartObject object Properties ZOrder
ChartObjects object Methods Add
ChartObjects object Methods Copy
ChartObjects object Methods CopyPicture
ChartObjects object Methods Cut
ChartObjects object Methods Delete
ChartObjects object Methods Duplicate
ChartObjects object Methods Item
ChartObjects object Methods Select
ChartObjects object Properties Application
ChartObjects object Properties Count
ChartObjects object Properties Creator
ChartObjects object Properties Height
ChartObjects object Properties Left
ChartObjects object Properties Locked
ChartObjects object Properties Parent
ChartObjects object Properties Placement
ChartObjects object Properties PrintObject
ChartObjects object Properties ProtectChartObject
ChartObjects object Properties ShapeRange
ChartObjects object Properties Top
ChartObjects object Properties Visible
ChartObjects object Properties Width
Charts object Methods Add2
Charts object Methods Copy
Charts object Methods Delete
Charts object Methods Move
Charts object Methods PrintOut
Charts object Methods PrintPreview
Charts object Methods Select
Charts object Properties Application
Charts object Properties Count
Charts object Properties Creator
Charts object Properties HPageBreaks
Charts object Properties Item
Charts object Properties Parent
Charts object Properties Visible
Charts object Properties VPageBreaks
ChartTitle object Methods Delete
ChartTitle object Methods Select
ChartTitle object Properties Application
ChartTitle object Properties Caption
ChartTitle object Properties Characters
ChartTitle object Properties Creator
ChartTitle object Properties Format
ChartTitle object Properties Formula
ChartTitle object Properties FormulaLocal
ChartTitle object Properties FormulaR1C1
ChartTitle object Properties FormulaR1C1Local
ChartTitle object Properties Height
ChartTitle object Properties HorizontalAlignment
ChartTitle object Properties IncludeInLayout
ChartTitle object Properties Left
ChartTitle object Properties Name
ChartTitle object Properties Orientation
ChartTitle object Properties Parent
ChartTitle object Properties Position
ChartTitle object Properties ReadingOrder
ChartTitle object Properties Shadow
ChartTitle object Properties Text
ChartTitle object Properties Top
ChartTitle object Properties VerticalAlignment
ChartTitle object Properties Width
ChartView object Properties Application
ChartView object Properties Creator
ChartView object Properties Parent
ChartView object Properties Sheet
ColorFormat object Properties Application
ColorFormat object Properties Brightness
ColorFormat object Properties Creator
ColorFormat object Properties ObjectThemeColor
ColorFormat object Properties Parent
ColorFormat object Properties RGB
ColorFormat object Properties SchemeColor
ColorFormat object Properties TintAndShade
ColorFormat object Properties Type
ColorScale object Methods Delete
ColorScale object Methods ModifyAppliesToRange
ColorScale object Methods SetFirstPriority
ColorScale object Methods SetLastPriority
ColorScale object Properties Application
ColorScale object Properties AppliesTo
ColorScale object Properties ColorScaleCriteria
ColorScale object Properties Creator
ColorScale object Properties Formula
ColorScale object Properties Parent
ColorScale object Properties Priority
ColorScale object Properties PTCondition
ColorScale object Properties ScopeType
ColorScale object Properties StopIfTrue
ColorScale object Properties Type
ColorScaleCriteria object Properties Count
ColorScaleCriteria object Properties Item
ColorScaleCriterion object Properties FormatColor
ColorScaleCriterion object Properties Index
ColorScaleCriterion object Properties Type
ColorScaleCriterion object Properties Value
ColorStop object Methods Delete
ColorStop object Properties Application
ColorStop object Properties Color
ColorStop object Properties Creator
ColorStop object Properties Parent
ColorStop object Properties Position
ColorStop object Properties ThemeColor
ColorStop object Properties TintAndShade
ColorStops object Methods Add
ColorStops object Methods Clear
ColorStops object Methods Item
ColorStops object Properties Application
ColorStops object Properties Count
ColorStops object Properties Creator
ColorStops object Properties Parent
Comment object Methods Delete
Comment object Methods Next
Comment object Methods Previous
Comment object Methods Text
Comment object Properties Application
Comment object Properties Author
Comment object Properties Creator
Comment object Properties Parent
Comment object Properties Shape
Comment object Properties Visible
Comments object Methods Item
Comments object Properties Application
Comments object Properties Count
Comments object Properties Creator
Comments object Properties Parent
ConditionValue object Methods Modify
ConditionValue object Properties Application
ConditionValue object Properties Creator
ConditionValue object Properties Parent
ConditionValue object Properties Type
ConditionValue object Properties Value
Connections object Methods Add
Connections object Methods AddFromFile
Connections object Methods Item
Connections object Properties Application
Connections object Properties Count
Connections object Properties Creator
Connections object Properties Parent
ConnectorFormat object Methods BeginConnect
ConnectorFormat object Methods BeginDisconnect
ConnectorFormat object Methods EndConnect
ConnectorFormat object Methods EndDisconnect
ConnectorFormat object Properties Application
ConnectorFormat object Properties BeginConnected
ConnectorFormat object Properties BeginConnectedShape
ConnectorFormat object Properties BeginConnectionSite
ConnectorFormat object Properties Creator
ConnectorFormat object Properties EndConnected
ConnectorFormat object Properties EndConnectedShape
ConnectorFormat object Properties EndConnectionSite
ConnectorFormat object Properties Parent
ConnectorFormat object Properties Type
ControlFormat object Methods AddItem
ControlFormat object Methods List
ControlFormat object Methods RemoveAllItems
ControlFormat object Methods RemoveItem
ControlFormat object Properties Application
ControlFormat object Properties Creator
ControlFormat object Properties DropDownLines
ControlFormat object Properties Enabled
ControlFormat object Properties LargeChange
ControlFormat object Properties LinkedCell
ControlFormat object Properties ListCount
ControlFormat object Properties ListFillRange
ControlFormat object Properties ListIndex
ControlFormat object Properties LockedText
ControlFormat object Properties Max
ControlFormat object Properties Min
ControlFormat object Properties MultiSelect
ControlFormat object Properties Parent
ControlFormat object Properties PrintObject
ControlFormat object Properties SmallChange
ControlFormat object Properties Value
CubeField object Methods AddMemberPropertyField
CubeField object Methods AutoGroup
CubeField object Methods ClearManualFilter
CubeField object Methods CreatePivotFields
CubeField object Methods Delete
CubeField object Properties AllItemsVisible
CubeField object Properties Application
CubeField object Properties Caption
CubeField object Properties Creator
CubeField object Properties CubeFieldSubType
CubeField object Properties CubeFieldType
CubeField object Properties CurrentPageName
CubeField object Properties DragToColumn
CubeField object Properties DragToData
CubeField object Properties DragToHide
CubeField object Properties DragToPage
CubeField object Properties DragToRow
CubeField object Properties EnableMultiplePageItems
CubeField object Properties FlattenHierarchies
CubeField object Properties HasMemberProperties
CubeField object Properties HierarchizeDistinct
CubeField object Properties IncludeNewItemsInFilter
CubeField object Properties IsDate
CubeField object Properties LayoutForm
CubeField object Properties LayoutSubtotalLocation
CubeField object Properties Name
CubeField object Properties Orientation
CubeField object Properties Parent
CubeField object Properties PivotFields
CubeField object Properties Position
CubeField object Properties ShowInFieldList
CubeField object Properties TreeviewControl
CubeField object Properties Value
CubeFields object Methods AddSet
CubeFields object Methods GetMeasure
CubeFields object Properties Application
CubeFields object Properties Count
CubeFields object Properties Creator
CubeFields object Properties Item
CubeFields object Properties Parent
CustomProperties object Methods Add
CustomProperties object Methods Application
CustomProperties object Methods Count
CustomProperties object Methods Creator
CustomProperties object Methods Item
CustomProperties object Methods Parent
CustomProperty object Methods Delete
CustomProperty object Properties Application
CustomProperty object Properties Creator
CustomProperty object Properties Name
CustomProperty object Properties Parent
CustomProperty object Properties Value
CustomView object Methods Delete
CustomView object Methods Show
CustomView object Properties Application
CustomView object Properties Creator
CustomView object Properties Name
CustomView object Properties Parent
CustomView object Properties PrintSettings
CustomView object Properties RowColSettings
CustomViews object Methods Add
CustomViews object Methods Item
CustomViews object Properties Application
CustomViews object Properties Count
CustomViews object Properties Creator
CustomViews object Properties Parent
Databar object Methods Delete
Databar object Methods ModifyAppliesToRange
Databar object Methods SetFirstPriority
Databar object Methods SetLastPriority
Databar object Properties Application
Databar object Properties AppliesTo
Databar object Properties AxisColor
Databar object Properties AxisPosition
Databar object Properties BarBorder
Databar object Properties BarColor
Databar object Properties BarFillType
Databar object Properties Creator
Databar object Properties Direction
Databar object Properties Formula
Databar object Properties MaxPoint
Databar object Properties MinPoint
Databar object Properties NegativeBarFormat
Databar object Properties Parent
Databar object Properties PercentMax
Databar object Properties PercentMin
Databar object Properties Priority
Databar object Properties PTCondition
Databar object Properties ScopeType
Databar object Properties ShowValue
Databar object Properties StopIfTrue
Databar object Properties Type
DataBarBorder object Properties Application
DataBarBorder object Properties Color
DataBarBorder object Properties Creator
DataBarBorder object Properties Parent
DataBarBorder object Properties Type
DataFeedConnection object Methods CancelRefresh
DataFeedConnection object Methods Refresh
DataFeedConnection object Methods SaveAsODC
DataFeedConnection object Properties AlwaysUseConnectionFile
DataFeedConnection object Properties Application
DataFeedConnection object Properties CommandText
DataFeedConnection object Properties CommandType
DataFeedConnection object Properties Connection
DataFeedConnection object Properties Creator
DataFeedConnection object Properties EnableRefresh
DataFeedConnection object Properties Parent
DataFeedConnection object Properties RefreshDate
DataFeedConnection object Properties Refreshing
DataFeedConnection object Properties RefreshOnFileOpen
DataFeedConnection object Properties RefreshPeriod
DataFeedConnection object Properties SavePassword
DataFeedConnection object Properties ServerCredentialsMethod
DataFeedConnection object Properties SourceConnectionFile
DataFeedConnection object Properties SourceDataFile
DataLabel object Methods Delete
DataLabel object Methods Select
DataLabel object Properties Application
DataLabel object Properties AutoText
DataLabel object Properties Caption
DataLabel object Properties Characters
DataLabel object Properties Creator
DataLabel object Properties Format
DataLabel object Properties Formula
DataLabel object Properties FormulaLocal
DataLabel object Properties FormulaR1C1
DataLabel object Properties FormulaR1C1Local
DataLabel object Properties Height
DataLabel object Properties HorizontalAlignment
DataLabel object Properties Left
DataLabel object Properties Name
DataLabel object Properties NumberFormat
DataLabel object Properties NumberFormatLinked
DataLabel object Properties NumberFormatLocal
DataLabel object Properties Orientation
DataLabel object Properties Parent
DataLabel object Properties Position
DataLabel object Properties ReadingOrder
DataLabel object Properties Separator
DataLabel object Properties Shadow
DataLabel object Properties ShowBubbleSize
DataLabel object Properties ShowCategoryName
DataLabel object Properties ShowLegendKey
DataLabel object Properties ShowPercentage
DataLabel object Properties ShowRange
DataLabel object Properties ShowSeriesName
DataLabel object Properties ShowValue
DataLabel object Properties Text
DataLabel object Properties Top
DataLabel object Properties VerticalAlignment
DataLabel object Properties Width
DataLabels object Methods Delete
DataLabels object Methods Item
DataLabels object Methods Propagate
DataLabels object Methods Select
DataLabels object Properties Application
DataLabels object Properties AutoText
DataLabels object Properties Count
DataLabels object Properties Creator
DataLabels object Properties Format
DataLabels object Properties HorizontalAlignment
DataLabels object Properties Name
DataLabels object Properties NumberFormat
DataLabels object Properties NumberFormatLinked
DataLabels object Properties NumberFormatLocal
DataLabels object Properties Orientation
DataLabels object Properties Parent
DataLabels object Properties Position
DataLabels object Properties ReadingOrder
DataLabels object Properties Separator
DataLabels object Properties Shadow
DataLabels object Properties ShowBubbleSize
DataLabels object Properties ShowCategoryName
DataLabels object Properties ShowLegendKey
DataLabels object Properties ShowPercentage
DataLabels object Properties ShowRange
DataLabels object Properties ShowSeriesName
DataLabels object Properties ShowValue
DataLabels object Properties VerticalAlignment
DataTable object Methods Delete
DataTable object Methods Select
DataTable object Properties Application
DataTable object Properties Border
DataTable object Properties Creator
DataTable object Properties Font
DataTable object Properties Format
DataTable object Properties HasBorderHorizontal
DataTable object Properties HasBorderOutline
DataTable object Properties HasBorderVertical
DataTable object Properties Parent
DataTable object Properties ShowLegendKey
DefaultWebOptions object Properties AllowPNG
DefaultWebOptions object Properties AlwaysSaveInDefaultEncoding
DefaultWebOptions object Properties Application
DefaultWebOptions object Properties CheckIfOfficeIsHTMLEditor
DefaultWebOptions object Properties Creator
DefaultWebOptions object Properties DownloadComponents
DefaultWebOptions object Properties Encoding
DefaultWebOptions object Properties FolderSuffix
DefaultWebOptions object Properties Fonts
DefaultWebOptions object Properties LoadPictures
DefaultWebOptions object Properties LocationOfComponents
DefaultWebOptions object Properties OrganizeInFolder
DefaultWebOptions object Properties Parent
DefaultWebOptions object Properties PixelsPerInch
DefaultWebOptions object Properties RelyOnCSS
DefaultWebOptions object Properties RelyOnVML
DefaultWebOptions object Properties SaveHiddenData
DefaultWebOptions object Properties SaveNewWebPagesAsWebArchives
DefaultWebOptions object Properties ScreenSize
DefaultWebOptions object Properties TargetBrowser
DefaultWebOptions object Properties UpdateLinksOnSave
DefaultWebOptions object Properties UseLongFileNames
Dialog object Methods Show
Dialog object Properties Application
Dialog object Properties Creator
Dialog object Properties Parent
Dialogs object Properties Application
Dialogs object Properties Count
Dialogs object Properties Creator
Dialogs object Properties Item
Dialogs object Properties Parent
DialogSheetView object Properties Application
DialogSheetView object Properties Creator
DialogSheetView object Properties Parent
DialogSheetView object Properties Sheet
DisplayFormat object Properties AddIndent
DisplayFormat object Properties Application
DisplayFormat object Properties Borders
DisplayFormat object Properties Characters
DisplayFormat object Properties Creator
DisplayFormat object Properties Font
DisplayFormat object Properties FormulaHidden
DisplayFormat object Properties HorizontalAlignment
DisplayFormat object Properties IndentLevel
DisplayFormat object Properties Interior
DisplayFormat object Properties Locked
DisplayFormat object Properties MergeCells
DisplayFormat object Properties NumberFormat
DisplayFormat object Properties NumberFormatLocal
DisplayFormat object Properties Orientation
DisplayFormat object Properties Parent
DisplayFormat object Properties ReadingOrder
DisplayFormat object Properties ShrinkToFit
DisplayFormat object Properties Style
DisplayFormat object Properties VerticalAlignment
DisplayFormat object Properties WrapText
DisplayUnitLabel object Methods Delete
DisplayUnitLabel object Methods Select
DownBars object Methods Delete
DownBars object Methods Select
DownBars object Properties Application
DownBars object Properties Creator
DownBars object Properties Format
DownBars object Properties Name
DownBars object Properties Parent
DropLines object Methods Delete
DropLines object Methods Select
DropLines object Properties Application
DropLines object Properties Border
DropLines object Properties Creator
DropLines object Properties Format
DropLines object Properties Name
DropLines object Properties Parent