Issues about Microsoft excel 2019 while using Mac os

%3CLINGO-SUB%20id%3D%22lingo-sub-2066654%22%20slang%3D%22en-US%22%3EIssues%20about%20Microsoft%20excel%202019%20while%20using%20Mac%20os%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2066654%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20executing%20Vba%20I%20get%20the%20following%20error%3A%3C%2FP%3E%3CP%3E%22%3CSPAN%3Eruntime%20error%20380%2C%20Could%20not%20set%20the%20rowsource%20property.%20Invalid%20property%20value%22%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESecondly%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EUser%20form%20icon%20is%20disabled%2C%20no%20way%20to%20see%2Fedit%20user%20form%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDue%20to%20these%20issues%20I%20cannot%20use%20VBA%20excel%20in%20Mac%20os%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2066654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067058%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20about%20Microsoft%20excel%202019%20while%20using%20Mac%20os%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931330%22%20target%3D%22_blank%22%3E%40sunilticku%3C%2FA%3E%26nbsp%3BThere%20are%20many%20resources%20on-line%20discussing%20this%20particular%20error.%20For%20example%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F56059277%2Fuserform-runtime-error-380-could-not-set-the-rowsource-property-fix%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F56059277%2Fuserform-runtime-error-380-could-not-set-the-rowsource-property-fix%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20regard%20to%20Userforms%2C%20I%20believe%20this%20functionality%20was%20removed%20from%20Excel%20for%20Mac%20in%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

While executing Vba I get the following error:

"runtime error 380, Could not set the rowsource property. Invalid property value" 

 

Secondly

User form icon is disabled, no way to see/edit user form

 

Due to these issues I cannot use VBA excel in Mac os

1 Reply

@sunilticku There are many resources on-line discussing this particular error. For example here:

https://stackoverflow.com/questions/56059277/userform-runtime-error-380-could-not-set-the-rowsource-... 

 

With regard to Userforms, I believe this functionality was removed from Excel for Mac in 2016.