combo box

[Carl Johnson]

How do I set up a combo box to show a range in another workbox.
Thanks in advance.

 

[icestationzbra]

some amount of detail on your question would help arriving at
solution.

for experimenting, i created a combobox in sheet1 in book1 and passed
range to it from sheet1 in book2.

Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift A
Integer, ByVal X As Single, ByVal Y As Single)

Sheet1.ComboBox1.AddItem "([Book2.xls]Sheet1!R1C1:R8C1)"

End Su

 

[Carl Johnson]

Sorry, let me try to explain what I'm trying to do.

I have one workbook called custlist with the id #'s and names of customers
which I created a range called t_customer.
In a workbook called Invoices I've set up a vlookup function in cell D5 to
find the name of the customer from the id# in cell d2. Since the custlist is
so large I thought that I could use a combo box in D2 using the range
t_customer so that end users would not have to try to keep referring to the
custlist workbook to retrieve the id #'s. Hope that explains what I'm trying
to do.