Combobox Macro on a MACintosh.

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!!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,113
Messages
5,570,266
Members
412,314
Latest member
yazanwael
Top