Select Row Allow cursor movement then return to macro EXCEL VBA

[artsandcraftshome]

I have a macro that needs input from the operator that is found on another sheet. I want to display this sheet with the appropriate row highlighted, allow the operator to "Cursor right or left", record the value in the appropriate cell, then have a way for the operator to return to the macro. I thought I could display the sheet with a Msg box telling them to cursor to find the value, but there needs to be a way to return to the macro.
So far I have this:

'get the row number:
SCDMAX = Range("D45&quot.Value
'select the sheet with the data:
Sheets("PDD TABLES&quot.Select
'select the row:
Row("SCDMAX&quot.Select
-->this is where I would put up a MsgBox telling them what to do but I need a way to return when done

If there's a way to retrieve the cell address (or contents) that the operator chose (e.g. they left the cursor on that cell) that would be even better!
thanks for any help
John

 

[combo]

In the VBA toolbox - add a component named RefEdit.Ctrl. If you can't find it - mark a reference to Ref Edit Control. If you can't find it - browse for REFEDIT.DLL.
Now you can create a custom dialog with it, if you point a cell it returns its address.

combo