Hello,

I'm working on a VBA subroutine which pauses the macro to allow the
user to select (with a mouse) a cell in a different workbook (which is
already open) and, for the cell selected, records the workbook name,
sheet name, and cell address to variables.

I've tried application.inputbox, but that seems to work only for the
current workbook; it won't let me select another workbook.

Does Excel offer another way to handle this? Any ideas?

Make sure that "application.screenupdating = true" then tell the user to use the
Window menu to get to other workbooks.

Stephen wrote:

Hello,

I'm working on a VBA subroutine which pauses the macro to allow the
user to select (with a mouse) a cell in a different workbook (which is
already open) and, for the cell selected, records the workbook name,
sheet name, and cell address to variables.

I've tried application.inputbox, but that seems to work only for the
current workbook; it won't let me select another workbook.

Does Excel offer another way to handle this? Any ideas?

--

Dave Peterson