DATA.FORM

Macro Sheets Only

Equivalent to choosing the Form command from the Data menu. Displays the data form.

If Microsoft Excel cannot determine what database or list of information to use, the function returns the #VALUE! error value and interrupts the macro.

Syntax

DATA.FORM( )

Remarks

• You can still use custom data forms created in Microsoft Excel version 4.0 or earlier. To edit the definition table of the custom data form, use the Dialog Editor from Microsoft Excel version 4.0.
• The data form can handle up to 32 fields.

Related Functions

List of Command-Equivalent Functions