combo box

C

Carl Johnson

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

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
 
C

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.
 
Top