View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JRA_MOHAWK[_2_] JRA_MOHAWK[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.