< Run-time error'380' Could not set the RowSource property. Invalid property value> on Mac

Hi,

I generated a VBA userform using 365. The code works fine on a PC. However, when I try to share the document with Mac users, I get a run-time error <Run-time error'380' Could not set the RowSource property. Invalid property value.> When I access the document on a Mac, the debugging error comes in the:

Sub Show_For ()
SampleSubmissionForm.()
End Sub

Can someone please help? Thanks in advanced

I have bad news. UserForms use ActiveX controls, and MacOS does not support them. (I assume your users are not using a Windows VM under MacOS.)

One option is to redevelop your project using a worksheet instead of a UserForm and use Forms controls instead of ActiveX, but you would have to rewrite all your code.

Controls on a userform are not activex. The issue you have is that listboxes and comboboxes do not have a Rowsource property on a Mac. You need to populate them using either the List/Column properties, or AddItem.

Originally Posted by rorya

Controls on a userform are not activex. The issue you have is that listboxes and comboboxes do not have a Rowsource property on a Mac. You need to populate them using either the List/Column properties, or AddItem.

I apologize for this mistake, I am misinformed.

(I cannot imagine why the available properties would be any different for supported controls on a Mac.)

I have no idea what the root cause is, but it's always been this way on Macs for whatever reason.