Excel equivalent of Lotus {?}
 

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.

Excel equivalent of Lotus {?}
 

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.

--
Regards,
Tom Ogilvy


"JRA_MOHAWK" wrote:

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.

Excel equivalent of Lotus {?}
 

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

"JRA_MOHAWK" wrote in message
...
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.

Excel equivalent of Lotus {?}
 

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

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


JRA_MOHAWK wrote:
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.

Excel equivalent of Lotus {?}
 

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

"Don Guillett" wrote:

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

"JRA_MOHAWK" wrote in message
...
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.

Excel equivalent of Lotus {?}
 

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.

--
Regards,
Tom Ogilvy

"JRA_MOHAWK" wrote in message
...
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

"Don Guillett" wrote:

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

"JRA_MOHAWK" wrote in message
...
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.