Excel Function
Excel Function (VBA)
Excel Method (VBA)
Excel Event (VBA)
This page lists all Excel Property for VBA that have been explained in http://Access-Excel.tips.
You may also want to read:
Differences among Function, Sub, Method, Property
Range Property
[table width=”750″ colwidth=”150|600″ ]
Property, Description
AskToUpdateLinks, Get or set whether to pop up automatic update external data message
Formula, Set / Get Formula from a cell
FormulaR1C1, Set / retrieve formula for a cell using relative row and column
Offset, Return the Range object away from a specific range
UsedRange, A Range area that has been used in the worksheet
[/table]
Application Property
[table width=”750″ colwidth=”150|600″ ]
Property, Description
Calculation, Change Workbook Calculation mode to Automatic / Semiautomatic / Manual
EnableEvents,
Screenupdating,
WorksheetFunction, Use Worksheet Function in VBA
[/table]
Dictionary Property
[table width=”750″ colwidth=”150|600″ ]
Property, Description
Item, Modify an Item in Dictionary
Key, Rename a Key of Dictionary
[/table]
Names Property
[table width=”750″ colwidth=”150|600″ ]
Property, Description
Comment, Return the Comment of Named Range
Delete, Delete Named Range
Name, Return Name string of the Named Range
RefersTo, Return the formula that the Named Range refers to
RefersToRange, Return the Range object that the Named Range refers to
Value, Return the the formula string that the Named Range refers to
[/table]
Other Property
[table width=”750″ colwidth=”150|600″ ]
Property, Description
ColorIndex, A custom Function to look for the first colored Cell
RGB, Set RGB Color for Cell or Shape
[/table]