Hello All,
I am working on some excel VBA code and I am a little - ok - a lot stuck on
a procedure I am trying to create.

I have 2 sheets in the workbook one called "produce code" and one called
"produce name"

On the produce code sheet are drop down boxes in each cell of column A that
contain the produce code, column B is blank. When a user selects a a code I
want to populate the cell beside it (column B) with the name located in the
worksheet "produce name"

The second worksheet ("produce name") has all the codes and names i.e.

Column A Column B
1 Banana
2 Apple
3 Orange

So when the user selects 1 in column A of worksheet "produce code" I am
trying to populate column B with "Banana". I can do this using vbLookup but
I want to do this using vba code.

My thought is putting column A when selected into a variable then looping
through Column A of the second worksheet to find a match and selecting the
value of the cell beside it.

Can anyone please help.

Thank you so much for your time

Dan