That's right. As I sad after that tip, if then name of sheet sounds "MAO
Description", rebuild your code to:

cboSiteID.RowSource = chr(39) & "MAO Description" & chr(39) & "!H2:H1332"

Regards
Mariusz

U¿ytkownik "Ayo" napisa³ w wiadomo¶ci
...
Still not working. I am not getting any errors but nothing is showing up
in
the combobox.

"MaC" wrote:

Well, I think you can modify it this way:

cboSiteID.RowSource = "MAO!H2:H1332"

Regards
Mariusz

U?ytkownik "Ayo" napisa3 w wiadomo?ci
...
This is what I have in my code, cboSiteID.RowSource = "H2:H1332", but
the
range h2:h1332 is on a sheet named MAO Description.

"MaC" wrote:

Have you put this in RowSource property in VBA editor?
It works for me, e.g.: Numbers!A1:A3.
BTW - another way is to use named range.

Mariusz

U?ytkownik "Ayo" napisa3 w wiadomo?ci
...
That didn't work.

"MaC" wrote:

Try: SheetName!a2:a10

Mariusz

How do I specifiy which sheet the range, a2:a10, is on.