To Add a Formula Property Definition to a Property Set Definition

Use this procedure to add a formula property definition to a property set definition. Formula property values can be computed based on the values of other property data. A formula property definition is a type of automatic property, because the value it displays is determined automatically, based on its definition, and cannot be edited directly.

Note: There is no conversion made between units for a formula result.

Formulas can be simple mathematical expressions, such as 2+2. They can also contain variables, operators, and functions allowed in VBScript, as shown in the examples below.

Statements
Call Statement	For Each...Next Statement	Property Get Statement	Set Statement
Class Statement	For...Next Statement	Property Let Statement	Sub Statement
Const Statement	Function Statement	Property Set Statement	While...Wend Statement
Dim Statement	If...Then...Else Statement	Public Statement	Set Statement
Do...Loop Statement	On Error Statement	Randomize Statement	With Statement
Erase Statement	Option Explicit Statement	ReDim Statement
Execute Statement	Private Statement	Select Case Statement

Functions
Abs	Escape	LBound	ScriptEngineMinorVersion
Array	Eval	LCase	Second
Asc	Exp	Left	SetLocale
Atn	Filter	Len	Sgn
CBool	FormatCurrency	LoadPicture	Sin
CByte	FormatDateTime	Log	Space
CCur	FormatNumber	LTrim	Split
CDate	FormatPercent	Maths	Sqr
CDbl	GetLocale	Mid	StrComp
Chr	GetObject	Minute	String
CInt	GetRef	Month	Tan
CLng	Hex	MonthName	Time
Conversions	Hour	MsgBox	Timer
Cos	InputBox	Now	TimeSerial
CreateObject	InStr	Oct	TimeValue
CSng	InStrRev	Replace	Trim
Date	Int, Fix	RGB	TypeName
DateAdd	IsArray	RTrim	UBound
DateDiff	IsDate	Right	UCase
DatePart	IsEmpty	Rnd	Unescape
DateSerial	IsNull	Round	VarType
DateValue	IsNumeric	ScriptEngine	Weekday
Day	IsObject	ScriptEngineBuildVersion	WeekdayName
Derived Math	Join	ScriptEngineMajorVersion	Year

1. Click Manage tabStyle & Display panelStyle Manager.

   The Style Manager is displayed with the current drawing expanded in the tree view.

2. Expand Documentation Objects Property Set Definitions.
3. Select the property set definition to change.
4. On the Definition tab, click .
5. On the Formula Property Definition worksheet, enter a name for the formula property.
   

6. If you do not want to use the formula as the description of the property, clear Use formula for description.
7. Enter the formula:

   If you want to…	Then…
   use a value that you supply	click in the Formula pane, and enter the value.
   use the value of another property definition in the formula	locate and double-click (or right-click, and click Insert) the definition in the Insert Property Definitions list. You can also select the definition, and press Insert.
   use a VBScript function	locate and double-click (or right-click, and click Insert) the function in the Insert VBScript code list. You can also select the function, and press Insert.
   evaluate the formula as a VBScript function	enter RESULT anywhere in the formula.

   The property definitions available for use in the formula must be applied to the same objects as the property set definition containing the formula.

   The names of property definitions used in the formula are displayed within brackets, such as [Width]. If a property definition belongs to a property set definition other than the one containing the formula, that name is displayed as well, such as [DoorObjects:Height].

   The formula property definition cannot be used in the formula it defines, as indicated by the and the addition of [Self] after its name. Property definitions that end up using the value of the formula cannot be used in the formula, as indicated by the and the addition of [Circular Reference] after their names.

   Note: If you enter the name of a property definition directly in the formula string, or copy and paste between formulas, the property definition is displayed as normal text. For property values of property definitions to be inserted correctly, they must be selected from the list in the Insert Property Definitions pane.
8. In the Enter Sample Values pane, enter a value.

   The property value you enter displays with the current format specified in the Sample Result pane.

9. In the Enter Sample Values pane, select a property data format.

   The format you select effects how the data in the Value column displays in the Sample Result pane and how the formula evaluates in the in the schedule table. It can be changed at any time.

10. Click OK twice.