I've been beating my brains out on this one since I'm new to VBA.

I have a UserForm that has several TextBoxes in it.

The user will enter an ID# in TextBox1, then TextBox2 and so on will be AutoFilled by taking data from a separate workbook called PR 1461 Data. In the PR 1461 Data workbook the ID# is in column A and the data to populate the other TextBoxes in the UserForm is in columns B thru I.

What is the code needed to accomplish this?

Thanks for any help!