Microsoft KB Archive/52063

Writing Multiplan Macros to Accept User Input PSS ID Number: Q52063 Article last modified on 03-28-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

This articles describes how to write macros in Multiplan Versions 3.x, 4.00, and 4.01 that allow you to enter text or numbers during execution of a macro. To enter text in a cell, use the ’AL (Alpha) command code. To enter numbers in a cell, use the ’VA (Value) command code. Shown below are examples of spreadsheets using these command codes.

More Information:

Demonstration One: Use of Alpha Command Code
  Select an unused area of the spreadsheet to store the macro. In this example, we will use Row 8 and Column 10.   Choose Goto Row 8 and Column 10.   Choose Alpha.   Enter the following text including the single quotation marks: ‘ALPlease enter your text’R5C4’ Press the ENTER key. It does not matter if you choose to move the cell pointer at this point before testing this macro.   Use the following procedure to test the macro:  Choose Goto. Select Macro. Enter “R8C10” without the quotation marks.</li> press the ENTER key.</li></ol> </li>  Verify that the following custom message appears in the message line: Please enter your text. </li>  Information entered is directly input into cell R5C4 in text format. Press the ENTER key when the entry is complete. </li></ol>

Demonstration Two: Use of Value Command Code
<ol style="list-style-type: decimal;">  Select an unused area of the spreadsheet to store the macro. In this example, choose Row 12 and Column 23. </li>  Choose Goto Row 12 and Column 23. </li>  Choose Alpha. </li>  Enter the following text: ‘VAPlease enter your number’R6C7’ Press the ENTER key. It does not matter if you choose to move the cell pointer at this point before testing this macro. </li>  Use the following procedure to test the macro: <ol style="list-style-type: lower-alpha;"> Choose Goto</li> Select Macro.</li> Enter “R12C23” without the quotation marks.</li> Press the ENTER key.</li></ol> </li>  Verify that the following custom message appears in the message line: Please enter your number. </li>  Information entered is directly input into cell R6C7 in number format. Press the ENTER key after entering the number. </li></ol>

Copyright Microsoft Corporation 1990.