Accesing a second workbook
 

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.

Accesing a second workbook
 

Something like this perhaps:

With Workbooks("Book2.xls").Worksheets("Sheet1")
TextBox1.Text = .Range("A1").Value
TextBox2.Text = .Range("A2").Value
End With

--
Jim
"Patrick Simonds" wrote in message
...
|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.
|
|