To use the RowSource to set the data for a combob/listbox you need to
identify it as a string (see the help file, it's quite clear on this).

listbox1.rowsource = "myData"

where "myData" is some named range or an explicit address
like "Sheet4!A4:A10"