Hi,

setting the linked cell will fail if you do it like this. see my response

Mike

"bobdpirate" wrote:

Please help me someone. I'm new at VBA but I know VB. I have several cells
with drop down lists. For example, column D rows 1-5 have drop down lists
associated with them. When I click on the cell, the list pops up and I
select a value. When that happens, I want to search for the selected text in
column C. I then want to copy the values of columns C and D in the row where
the text was found and paste those values in column E and F on the row where
the drop down list was activated. I know this sounds complicated, and I hate
to ask for someone else to write code for me. But this is a one time job
that I need to do and I don't have time to become well versed in VB for
Excell. I would appreciate the help. I am a Labview expert and I often help
and write small code for other beginners in the Labview forum. So I guess
I'm doing my part in one language and would like help in another language in
return.
--
Bob D Pirate