ExcelBanter - ListFillRange

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ListFillRange (https://www.excelbanter.com/excel-programming/274162-listfillrange.html)

Dave Baranas

ListFillRange

I am trying to populate a combobox's listfillrange with cells on a
different sheet

e.g.

ComboBox1.ListFillRange = Worksheets ("SheetXYZ").Range("AB100:AB200")

this gives me Run-Time error '1004"

Application-Defined or Object-Defined Error

Is there a way to do this?

Dan E[_2_]

ListFillRange

ComboBox1.ListFillRange = "'SheetXYZ'!AB100:AB200"

ListFillRange expects a string object not a range object

Dan E
"Dave Baranas" wrote in message ...
I am trying to populate a combobox's listfillrange with cells on a
different sheet

e.g.

ComboBox1.ListFillRange = Worksheets ("SheetXYZ").Range("AB100:AB200")

this gives me Run-Time error '1004"

Application-Defined or Object-Defined Error

Is there a way to do this?

All times are GMT +1. The time now is 09:55 AM.