Excel: Can't Use Mouse to Select Cells from Custom Input Box

ID: Q105213


The information in this article applies to:


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.


MORE INFORMATION

Steps to Reproduce Problem

  1. 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: 


  2. 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.


  3. Run this macro and note that you are able to point to cell references with your mouse.


  4. 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.



REFERENCES

"User's Guide 2," version 4.0, page 276
"Function Reference," version 4.0, page 122

Additional query words: 4.00a mode click


Keywords          : 
Version           : 4.00 4.00a
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 7, 1999