select entire row from a lookup

[JR]

I need to allow users to make a selection from a dropdown then I want code to
select the entire row (in this instance A throuhg J), copy the row and paste
it into a customizable list.

Can anyone tell me how to select an entire row in that manner?

Thanks.

 

[Rick Rothstein]

What is in the dropdown? Your subject line mentioned "lookup"... are you
trying to lookup what the user picked? Is so, where did you want to look
at... a column, a row, a range of cells? You mention that you want to select
and then copy... odds are you do not have to select to do your copy, but to
know for sure, you need to tell us about your "customizable list". Where
and/or what is it... an array in memory, a String variable, a range of
cells, something else? The more details you tells us, the better answer one
of us will be able to provide for you.

 

[JR]

What is in the dropdown?

it is a dropdown from a list

Your subject line mentioned "lookup"... are you
trying to lookup what the user picked? Is so, where did you want to look
at... a column, a row, a range of cells?

The list is "looking" at a column.

You mention that you want to select
and then copy... odds are you do not have to select to do your copy, but to
know for sure, you need to tell us about your "customizable list". Where
and/or what is it... an array in memory, a String variable,

a range of cells, >>> the row of which the lookup column selected cell is
located

 

[Cesar]

Hello JR,

I have the same problem and I'm still looking for the best way to do this,
did you find a way to do it? does that code from thecodecage work? Please
reply