RowSource issue with combobox

[kelly mort]

Hello everyone,
I have a combobox called ComboBox1 with is populated by a rowsource. The combobox is on a userform. The issue is that I also have a listbox that populates the ComboBox1 when I click it. Since it (ComboBox1 ) was populated by the rowsource, I get an error when I click it. So I decided to clear the items in it (ComboBox1 ) when I click the listbox before the listbox populates the textboxes of which the ComboBox1 is part. I used :

ComboBox1.Rowsource = ""

And I have been able to bypass the error however I wanna get the lists back in the ComboBox1. I am stucked. I need help
I have tried:

ComboBox1.Rowsource = Sheet1.Range("myList")

But did not work

Thanks

 

[RoryA]

RowSource requires the address/name of a range (i.e. a String), not a Range object or its contents.

 

[kelly mort]

RowSource requires the address/name of a range (i.e. a String), not a Range object or its contents.

Okay so how resolve my issue here?
Kelly

 

[RoryA]

By passing the name or address of the range - for example:

ComboBox1.Rowsource = "myList"

 

[kelly mort]

Thanks very much.