mcfly
Board Regular
- Joined
- May 15, 2002
- Messages
- 162
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!!
(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!!