PDA

View Full Version : Combo-box to Reference data in a different workbook/Sub-Folder



RalphMHill
11-14-2013, 02:40 PM
I have a Workbook that I would like to use a Combo-box to Reference data in a different workbook, in a different sub-Folder.
Example:
Current Workbook Name: 'C:\Forms\[C-Form.xlsm
Data workbook Name: 'C:\Data Sets\[CustomerData.xlsx
Data for the Combo-box is located in 'C:\Data Sets\[CustomerData.xlsx]Customers' $B:$B
In addition How can I bring back additional Values based on the customers Selection from the Combo-box (C-Form.xlsm)? I was using Vlookup formulas
SAMPLE

"=VLOOKUP(R[-1]C,'C:\Forms\[CustomerData.xlsx]Customers'!C1:C26,2,FALSE)"
OR

"=VLOOKUP(L10,'C:\Forms\[CustomerData.xlsx]Customers'!$A:$Z,5,FALSE)

If the customer selects the Name: ABC Co. from the Combo Box located in Cell - L10 ('C:\Forms\[C-Form.xlsm]Sheet1') I can propagate the fields for L11 - L16 with information from 'C:\Forms\[CustomerData.xlsx]Customers' $B-$G
SAMPLE
B1 C1 D1 E1 F1 G1
Name Address City State Zip ID Number
ABC Co. 123 Main St AnyTown Ohio 12345 C-10034
123 Inc. 256 Smith Ave MyPlace Iowa 98765 C-10035
Your Assistance in this matter will be greatly appreciated.

Doug Robbins
11-15-2013, 04:45 PM
See the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htmWhile that is written for use in Word, it can easily be adapted for use in Excel. You could populate the combobox with the data from Columns B to G and then you just various columns of the combobox to get the balance of the data for the selected company.