Microsoft KB Archive/27311

-

{| 2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS                 | OS/2 kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

SUMMARY
To input a reference during the execution of a macro, you can specify a range by selecting the range instead of typing the reference.

MORE INFORMATION
Use the standard INPUT macro function (the same function you use for inputting numbers or text). If Type 8 is used, you can select cells on the worksheet as input. The selection is outlined instead of highlighted. For example, the following input statement can be used:

=INPUT(&quot;Select a range&quot;,8,,,300,200) This statement puts the box near the bottom of the screen. If you want to completely hide the box, use larger x-y coordinates. For example, the following input statement is not shown on the screen, so cells can be selected as input without the input box being used (except that the selection is outlined instead of highlighted): =INPUT(&quot;Select a range&quot;,8,,,400,400)
 * }

-

Last reviewed: November 4, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.