Using the Input Box to Select a Range in Excel

 Last reviewed: November 2, 1994
Article ID: Q27311
The information in this article applies to:
  • 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("Select a range",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("Select a range",8,,,400,400)

KBCategory: kbusage
KBSubcategory:

Additional words: 5.00 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00
3.0 4.00 4.0

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.