Reference to a range in an Excel Add-In

S

Sean

Hello,

Can someone please tell me if it is possible to use a
range in an installed .XLA file as the ListFillRange of a
combobox?

I have defined a range in my normal spreadsheet which
refers to the said range by using MyXLARange
= "=PDFInfo.xla!DBSeansTestRange". The ListFillRange of a
combobox is then set to MyXLARange. The result is the
combo box displays a garbled list of entries which,
although apparently correct in row number, repeats only a
few of the row entries time and time again.

Any ideas on this would be greatly appreciated.

Sean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent automatic combobox event trigger 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Excel ActiveX Combo - AutoComplete and LIst Issues 2
Creating a named range in a workbook using VBA 1
Find Specific Rows in Range and Create New Tab 18
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht 0
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht 11
Excel 07 vs. 03 "listrows" reference <subscript out of range> 2

Top