CODEWITHSUNDEEP
excelcombobox
Jlisk
Jlisk

Reputation: 333

Excel Combobox ListFillRange RC adressing

I need to populate an Excel combobox via Properties - Combobox window, ListFillRange property (NOT through code). I am able to do it if I put in A1:A10, but I need it in RC style. (1,1);(1,10) style. Is it possible? How?

Upvotes: 0

Views: 56

Answers (1)

Rory
Rory

Reputation: 34055

All they need to do is enter it as say Sheet1!R1C1:R10C1 and Excel will automatically change it to the relevant A1 style address

Upvotes: 1

Related Questions