Row source missing on Mac computer. What's the alternative solution.

Question

I have excel version 2011 on my Mac computer.  When trying to use a combo box or list box in VBA I am not able to find the "rowsource" column in the properties box.  Is there another column name used in it's place or am I doing something wrong?  Any assistance would be greatly appreciated.

Answer 1

You are not doing anything wrong. rowsource does not exist (work) on the Mac. Try using index instead.

Hi Bob,

Sorry to say but frankly that is one of the worst answers ever given.  :-(

"Use index instead".  The worksheet function INDEX( ?  Make your own Index ?  The VBA verb index ?  Your answer gives no specifics whatsoever !

As a PC EXCEL expert user, I came to your answer looking for simple help on why my perfectly functioning comboboxes on my Userforms don't work AT ALL on a MAC and I am still well and truly in the dark after reading your answer.

Fortunately a bit more googling and eventually (about 20 minutes worth)  I find that the simplest way to solve this problem is to assign the list values to the combobox whenever the userform is initalised :

Private Sub UserForm_Initialize()
    ComboxFieldName.List = Worksheets("mySheet").Range("A23:A30").Value' or...    myComboBox.List = Range("MyNamedRange").Value   '** if using a workbook-global named rangeEnd Sub

God only knows why Microsoft have deliberately left the code base for Excel on a MAC soooooooo limited compared to the PC version after all these years... but that's another question altogether I guess... :-)

Answer 2

This simple code has worked for me:

Private Sub UserForm_Initialize()

    food = Range("list!$C$3:$C$10")

    cmbM1.List = food

    cmbM2.List = food

End Sub

Hope this will help you to  :)

Regards

Peter

Answer 3

Private Sub UserForm_Initialize() ComboxFieldName.List = Worksheets("mySheet").Range("A23:A30").Value' or... myComboBox.List = Range("MyNamedRange").Value '** if using a workbook-global named rangeEnd Sub

Comboboxes on Excel for Mac are hamstrung compared to the PC.  You have to load the values into the combox yourself.  See above. :-)

Answer 4

Yes peter, that's a specific example of the exact code I posted.

I just made sure that the code I posted was full & explicit so that people could know exactly how to use it in multiple situations and it would work on all Excel versions.

Cheers,

Answer 5

You are not doing anything wrong. rowsource does not exist (work) on the Mac. Try using index instead.