Start Macro, pause for Row/Cell selection, then continue...

[Chris T-M]

Background:
I am launching a Macro from a Validation List (per 3/28/07 Post "Launching
Macro from Validation List")... therefore I can't pre-select a row to work
from using a command like "Range(CrntRow).Select" (I know there is more code
involed, but I don't think it will work in my case anyway).

What I've done:
My macro worked with a pre-set Row Number, but I can't figure out how to do
the follwing:

What I need:
After the Macro is launched in Workbook A, Then...
1) I want to prompt the user to select a Row (to perform my macro on),
2) Then I want to store that Row as a variable (specifically A##), and
continue the macro, (I have placed a Hyperlink in column A that directs the
Macro to the Workbook with the desired data: Workbook B)
3) Then I want to return to the selected Row with collected data (from
Workbook B) to paste into specific columns in the Row.


I have asked this differently, and only got 1 question, with no further
responses even after answering the question, so i hope my problem statement
is clearer this time. My deadline for getting this to work is 1st thing
Monday so any leads would be very much appreciaed.

Thanks in advance,
Chris T_M

 

[Bob Phillips]

Look at Application.InputBox

myRow = Application.Inputbox("Select a row", Type:=8).Row

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Chris T-M]

Such a simple thing, and it worked great.

I have looked for an answer to this for 2 weeks. I've never been so excited
to see a message box!

Thank you very much.
Chris T-M