Jun 26 2020 09:57 AM
Hello,
I am trying to use the Visual Basic on my Mac but when I Click on "worksheet" to type the code this message appears to me:
"Variable uses an Automation type not supported in Visual Basic"
Jun 26 2020 10:58 PM
Can you give us a clue about what code you are using and on which Module i.e. on Sheet Module or on Standard Module?
Jun 27 2020 09:23 AM
I didn't use any code because the excel wouldn't let me type anything on the worksheet, that's when the message appears to me.
Developer > Visual Basic > Worksheet > The error appears
Jun 27 2020 09:44 AM
See if the following links address the issue you are having.
https://excelvbaisfun.com/mac-excel-vba-events/
Jun 27 2020 10:01 AM
Thank you, that is the exact problem I'm having. After I type the code on the link you sent me the error stops appearing, but what do I do after I type this there? @Subodh_Tiwari_sktneer