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!