Mac error 380 with UserForm ComboBox.RowSource

[Mustang0710]

I have a ComboBox what works great on Windows PCs, but gives me an error 380 on the Mac.

The UserForm_Initialize subroutine has a problem with this line:
cb_NodeID.RowSource = "Node!B2:B" & NLastRow

In my test file, NLastRow = 371, so the RowSource will resolve to "Node!B2:B371"

I tried to include the single quotes like this:
cb_NodeID.RowSource = "'Node'!B2:B" & NLastRow
<strike></strike>
But neither one works.

Thanks for your help!

 

[RoryA]

Rowsource just doesn't work on a Mac. Use the List property and assign the value of the range to it.

 

[Mustang0710]

Thanks Rory

Can I set the List property as a range or do I have to loop through all the possible values and use .AddItem to create the list?

Thanks,

David

 

[RoryA]

cb_NodeID.list = sheets("Node").range("B2:B" & NLastRow).value

basically.

 

[Mustang0710]

Works great Rory...Thank You!

 

[RoryA]

Glad to help