Combobox Macro on a MACintosh.

[mcfly]

I created a userform on my pc, and on this userform I am using a combobox(obcolor) and I have it setup to use a list on another sheet
(sheet2!a1:a30) and I setup my code to be:

Private Sub OBCOLOR_Change()
OBCOLOR.RowSource = "Sheet2!a1:a30"
End Sub

But when I use this on a mac it doesn't work.

So I looked at the properties window on a MAC and it doesn't have a rowsource.
Does anyone know how I can get around this to make it work?

Thanks in advance!!

 

[aeroballer]

I need help with this too!

 

[lazystateworker]

Me too, I'm boggled