Microsoft KB Archive/105213
Excel: Can't Use Mouse to Select Cells from Custom Input Box
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a
In Microsoft Excel, if you are using a reference edit box (item 10) in a custom dialog box, you will be unable to select a cell with your mouse if the macro function ECHO(FALSE) is used before the dialog box is called or if the custom dialog box is nonmoveable. This situation also applies to an input box generated using the INPUT() macro function.
Steps to Reproduce Problem
In a new macro sheet, create the following dialog box definition table:
A1:ITEM B1:X C1:Y D1:WIDTH E1:TEXT F1:RESULT G1: A2: B2: C2: D2:182 E2:62 F2:Select G2: A2:10 B2:10 C2:6 D3:160 E3: F3: G3: A3:2 B3:10 C3:31 D4:160 E4: F4:Cancel G4:
On the same macro sheet, enter the following macro
A6: =DIALOG.BOX(<TableRange>) A7: =RETURN()
where <TableRange> refers to the reference A2:G4 for the table above.
- Run this macro and note that you are able to point to cell references with your mouse.
Add the following line to the beginning of the macro:
When you run this macro, you will be unable to point to the cell references in the dialog box Reference field.
"User's Guide 2," version 4.0, page 276
"Function Reference," version 4.0, page 122
Additional query words: 4.00a mode click
Version : 4.00 4.00a
Platform : WINDOWS
Issue type :
Last Reviewed: April 7, 1999