1-2-3 NOTES All Versions Note 101 June 22, 1984 AUTOMATIC POINTER MOVEMENT MACROS ::::::::::::::::::::::::::::::::: SUMMARY An automatic pointer movement macro automatically moves the cell pointer each time you press the Return key. It is helpful if you need to make a number of entries in a column or row. This macro enables you to move the pointer while using the numeric keypad to make entries. It saves you the trouble of having to turn the numeric keypad on and off to move the pointer. (Pressing the Num Lock key so that you can use the numbers on the [23;1H[J Key S or to continue[23;30H!s [23;1H[J numeric keypad disables the pointer movement, or arrow, keys.) This macro is also helpful if you have a long list of labels to enter in a column or row. It does not save keystrokes per se, but it does allow you to type the list without moving your hand off the standard typewriter keys to press an arrow key. Once an automatic pointer movement macro is written, it is simple to use: activate the macro, type your data, and press the Return key. This note describes four macros, one for each direction: * the Up Macro * the Left Macro * the Down Macro * the Right Macro ::::::::::::::::::::::::::::::::::::::::::::::::::::::::: MACRO An automatic pointer movement macro has the COMMANDS following format (this is the Down Macro): {?}{down}/xg\D~ The following macro commands are used: {?} This symbol tells the macro program to pause until you type in the necessary data. After you type the data and press the Return key, the program reads the macro instructions that follow the {?}. {up} The pointer movement keys (or arrow keys) are {down} specified in the macro by name. The macro {left} moves the pointer in the direction indicated. {right} /xgLOCATION~ This command sends the macro program to another cell or range location where it will continue to read keystrokes. The /xg command is used to create the loop necessary to move the pointer elsewhere in the same column or row; it actually sends the program back to the beginning of the macro, enabling the same macro instructions to be used repeatedly. \ A backslash followed by a single letter is a "macro range name." Use the Range Name Create command to name macro with the \ and any letter of the alphabet. ~ The tilde stands for the Return key in a macro. It must be placed at any point in the macro se- quence where you would normally press the Return key if you were entering data and commands manu- ally. ::::::::::::::::::::::::::::::::::::::::::::::::::::::::: AUTOMATIC The Down Macro POINTER -------------- MOVEMENT MACROS This macro moves the pointer down one cell after you press the Return key. 1. Type the macro in one cell: {?}{down}/xg\D~ (press RETURN) 2. Give the macro the range name \D with the /Range Name Create Command. Place the pointer on the cell that contains the macro and type: /rnc\D (press RETURN 2 times) The Up Macro ------------ This macro moves the pointer up one cell after you press the Return key. 1. Type the macro in one cell: {?}{up}/xg\U~ (press RETURN) 2. Name the macro \U. Place the pointer on the cell that contains the macro and type: /rnc\U (press RETURN 2 times) The Right Macro --------------- This macro moves the pointer one cell to the right after you press the Return key. 1. Type the macro in one cell: {?}{right}/xg\R~ (press RETURN) 2. Name the macro \R. Place the pointer on the cell that contains the macro and type: /rnc\R (press RETURN 2 times) The Left Macro -------------- This macro moves the pointer one cell to the left after you press the Return key. 1. Type the macro in one cell: {?}{left}/xg\L~ (press RETURN) 2. Name the macro \L. Place the pointer on the cell that contains the macro and type: /rnc\L (press RETURN 2 times) Note: The macro is entered as a label. As you ===== type the macro it appears on the status line (in the upper left corner of the monitor). Notice that 1-2-3 automatically enters the apostrophe (') that denotes a label before the macro itself. You don't have to type the ' character. ::::::::::::::::::::::::::::::::::::::::::::::::::::::::: USING To use one of the macros: THE MACROS 1. Position the pointer in the cell in which you want to enter data. 2. Simultaneously press the Alt key and one macro letter name: D, U, R, L. (You do not have to type a capital letter when using the macro). 3. Type the data and press the Return key. 4. To get out of the macro and return to the 1-2-3 Ready mode, simultaneously press the Ctrl and Break (Scroll Lock) keys. An automatic pointer movement macro contains a continuous loop. Thus, this procedure is necessary to break out of the loop and end the macro (i.e., turn it off). To use a macro with the numeric keypad, simply press the Num Lock key and then do the same as above. The pointer will move in the specified direction, and the number keys can be used to enter values in the worksheet. are over $100, the value for 5 percent of the current sales over $100 will be disp