ActiveX Queries - combobox, Source data in another workbook.

  • Thread starter Thread starter Laurence Lombard
  • Start date Start date
L

Laurence Lombard

Two queries:

I have a list of ClientNumbers and ClientNames (I have named the range
ClientData). I want the Combobox to show just the ClientNumber but the drop
down portion must show the number and the name.

With
Listfillrange = ClientData
Boundcolumn = 1
Columns = 2
Columnwitdths = 40pt;150pt
Autosize = True

the second column is not displayed for its full width. Can I adjust this
without making the combobox permanently wide.

Is it possible to have the listfillrange in another workbook with the
listfillrange workbook closed. I copied the sheet with the Combobox to a new
workbook. The reference of the Source data range is correctly show (full
path) but when I close the workbook with the source data, the Combobox is
empty. Can I work around this.

Thanks
Laurence
 
Maybe making the font smaller in the combobox???

How about having a worksheet (hidden???) in your workbook with formulas that
point back to that other workbook?
 
Back
Top