Problem with Froms using MacOS 365

[288enzo]

My macro works perfectly on a PC machine, but now I'm trying it on a Mac and am getting Run-time error 380. Could not set the RowSource property. Invalid property value.

Is someone familiar with 365 for a Mac?

This is the code in question.

Private Sub CommandButton1_Click()
    If Area_Input.ComboBox1.Value = "" Then
        MsgBox ("Choose an Area to proceed")
    Else
        Me.Hide
    End If
End Sub

 

[MARK858]

You can't use ActiveX controls in a Mac. Use a forms button instead.

 

[RoryA]

You cannot use the RowSource property on a Mac. Use the List property and assign the range's value to it.

 

[288enzo]

I just found out that "User Forms" isn't available in the latest iteration of Excel 365 for the Mac. Ugh, so stupid.

 

[RoryA]

User forms are available to use, but there is no designer.

 

[288enzo]

User forms are available to use, but there is no designer.

That's not helpful at all, I would have to bounce back and forth to make changes to the form.

Not directed to you by any means.

 

[RoryA]

That's not helpful at all

I know - and it’s been 6 years!