Microsoft KB Archive/105213

{|
 * width="100%"|

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

-

SUMMARY
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() A7: =RETURN

where  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:

     A5:=ECHO(FALSE)

When you run this macro, you will be unable to point to the cell references in the dialog box Reference field. 