Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Data From Closed Workbook | Excel Worksheet Functions | |||
add data to a closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming | |||
getting data from closed workbook | Excel Programming |