I have a UserForm which is called from Workbook1. The userform has a LiskBox
which is populated from a range of cells on Workbook2, worksheet named
Employees.

What I would like to do is include some Textboxes which are also populated
from Workbook2, based on what is selected in the Listbox. The ListBox data
comes from Column A (combined First and Last name) and column B is the First
Name only, column C Is last Name only and column D is department code.

So I guess what I need is code that, while not making Worbook2 active, will
find the value selected in the Lisbox and then select the source cell on
Workbook2.