Share via


Default Values For Dialog Box

This dialog box appears when you click a Default Values field for an argument in the Custom Function Properties dialog box.

The complete dialog box name appends the selected argument's name and type. For example, if you select a DateTime argument called "DayInQuarter," the dialog box name appears as "Default Values for DayInQuarter (Date Time)."

The "Default Values for" dialog box lets you create a set of default values to be used in the Formula Expert.

Use the upper list to create the default values you want your users to see. You can enter values directly or, as in the case of date values, select from a calendar or list.

The lower list contains the values you have defined. That is, it contains the values your users will see in the Formula Expert.

Add Use the Add button to add values from the upper list to the lower list.
Remove Use the Remove button to remove values from the lower list.
Up and Down Use the Up and Down buttons to reorder values in the lower list.