Excel equivalent of Lotus {?}

[Guest]

Using Microsoft Office Excel 2003.

When I used to write macros in Lotus 123, I could use a macro command "{?}"
to suspend macro execution until the enter key was pressed. With execution
suspended, you could use the keyboard to move the cellpointer anywhere in the
file, then press enter and execution would resume. This was very helpful
when entering data into a spreadsheet with inconsistant numbers of rows or
columns between a series of entry fields. The "Inputbox" function doesn't
suffice, because I need to be able to manually move the cell pointer to a new
field. Any help would be greatly appreciated.

 

[Guest]

There isn't any support for that capability in VBA.

Suggested workarounds include splitting into two macros, then terminating
the first part and using the selection change event or change event to run
the second part of your macro.

 

[Don Guillett]

Have a look in the vba help index for inputbox method
example given
Worksheets("Sheet1").Activate
Set myCell = Application.InputBox( _
prompt:="Select a cell", Type:=8)--
Don Guillett
SalesAid Software
(e-mail address removed)

 

[acampbell012]

You could use OnEntry to control the additional routine(s)

Run routine 1
End
Select your cell
Enter your data
Run Routine 2

 

[Guest]

Don,
You started me in the right direction. Thanks. The routine that finally
works is:

Application.Goto Application.InputBox(prompt:="Select a cell", Type:=8)

Thanks again.

jra

 

[Tom Ogilvy]

If you are coding actions the same as you did in Lotus, you might want to
learn how to code in VBA. For example, to determine where to place
information on the worksheet, usually doesn't require the user selecting
cells. Selecting is almost never necessary and slows down code execution.
Just a thought.