Hi Team, I have one userform in one workbook (called here wbWorkbook1) in which I have a listbox (called here lstGroup7), everytime the user selects one value from it and click on commad button cmdOK, Excel must perform a VLOOKUP with a range (rngWB2) on another workbook (here called wbWorkbook2) and paste on the selected cell from (wbWorkbook1) the value on the left cell from the found value (see table example below). I have pasted below the code I have written and indicate the line where it errors out. Could anyone please advise what I am doing wrong?
B1 VALUE 1
B2 VALUE 2
B3 VALUE 3
this range is in wbWorkbook2.worksheets("sheet1") in case "value 2" is selected in the ListBox, "B2"is to pasted in the activecell from (wbWorkbook1)
Bookmarks