| title | manager | ms.date | ms.audience | ms.topic | f1_keywords | ms.localizationpriority | ms.assetid | description | |
|---|---|---|---|---|---|---|---|---|---|
Prompt Cell (User-Defined Cells Section) |
lindalu |
03/09/2015 |
Developer |
reference |
|
medium |
d0f91e7d-2373-cfef-e105-fb17e77c7f2d |
Specifies a descriptive prompt or comment for the user-defined cell. The application automatically encloses the prompt text in quotation marks () to indicate that it is a text string. If you type an equal sign (=) and omit the quotation marks, you can enter a formula in this cell that the application evaluates. |
Specifies a descriptive prompt or comment for the user-defined cell. The application automatically encloses the prompt text in quotation marks (" ") to indicate that it is a text string. If you type an equal sign (=) and omit the quotation marks, you can enter a formula in this cell that the application evaluates.
To get a reference to the Prompt cell by name from another formula, or from a program using the CellsU property, use:
| Value | |
|---|---|
| Cell name: |
User. Name .Prompt where User. Name is the row name |
To get a reference to the Prompt cell by index from a program, use the CellsSRC property with the following arguments:
| Value | |
|---|---|
| Section index: |
visSectionUser |
| Row index: |
visRowUser + i where i = 0, 1, 2... |
| Cell index: |
visUserPrompt |