Rowsource 1

[Igwiz]

Am I right in thinking that when you are assigning the rowsource or controlsource of a combobox, you have to use explicit cell references and can't use range names?

This works:
ComboBox1.RowSource = "'[book1.xls]Sheet1'!$A$1:$A$10"

But this doesn't
ComboBox1.RowSource = "'[book1.xls]Sheet1'!RangeToUse"

Can you use range names?

Thanks.

IG

 

[xlbo]

try this:
ComboBox1.ListFillRange = Range("rangetouse&quot.Address

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Igwiz]

Hi Geoff,

Doesn't like it. I get a compile error saying "Method or data member not found". I forget to mention that I am doing this for a form and the code is in the userform_initialize routine.

Thanks,
Ig

 

[xlbo]

for some reason, in a worksheet, you have to use the ListFillRange. On a userform it is Rowsource so
ComboBox1.rowsource = Range("rangetouse&quot.Address

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Igwiz]

Brilliant! It was the fact I was missing off the .address that stopped it working. Many thanks and a star.

Ig

 

[xlbo]

Need to use "Address" as the rowsource / listfillrange take a STRING source rather than a range

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244