Getting Data from closed workbook into userform
 

Hi

I want a userforn to search for and get data from multiple cells on the same
row of a closed worksheet. Then display the data on the userform, in a
number of labels/textboxes, for the user to review (and if requried, enter
on the active worksheet by the click of a command button). Now the entering
to the active worksheet I can do but its getting the data from the closed
workbook where I am struggling.

Can anyone give me some ideas on how to do this?

Upto now I have been using vlookup to find and enter the data in the active
worksheet and then we delete it if not needed. But with a vlookup in 18
columns this can be a pain. Below are some of the 'vlookups' I use, is there
an easy way to put this same functionality into a userform?

'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,2,FALSE)'

'=VLOOKUP(A15,'J:\rev_accs\[CSPost2003.xls]CBNW'!$1:$65536,12,FALSE)'

Kind Regards and thanks in advance for any help