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.