Refer to Combobox on another sheet

[dreddster]

Hey guys,

A basic question:
I have a macro to set ListFillRange on a Combobox.

When the combobox is on the current sheet it works like a charm with:

Please Login or Register  to view this content.

But if I put the combobox on another sheet and try:

Please Login or Register  to view this content.

I get an error "object doesn't support this property or method".

How do I refer to the combobox on sheet HR?

Thank you in advance!

[dreddster]

Ok changed it like that and it is working fine.

Please Login or Register  to view this content.