The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you run a macro that contains the InputBox method or function, if you select a range of cells while the Input dialog box is open, you receive the following error message when you choose OK:
CAUSEThe InputBox method or function displays a dialog box that prompts you for input. While the edit box in the Input dialog box is active, you can select cells on a worksheet to enter the range as input in the dialog box. However, when you select a range of cells on a worksheet in a workbook other than the workbook from which you ran the macro, you receive the error message described above. For example, if Workbook1 is active when you run a macro that contains the InputBox method, and you select cells on Workbook2 while the Input dialog box is open, when you choose OK, you receive the "error type 11" error message. WORKAROUNDSTo work around this problem, select the workbook that contains the range that you want to select in the Input dialog box before you run the macro that contains the InputBox method or function.STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0a for the Macintosh. REFERENCESFor more information about the InputBox Function or the InputBox Method, choose the Search button in the Visual Basic Reference and type: InputBox Additional query words: XL5
Keywords : kbcode kbprg xlmac |
Last Reviewed: September 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |