Excel VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1492602%22%20slang%3D%22en-US%22%3EExcel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492602%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201421i278A9941ADAA14B6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83I%20am%20trying%20to%20use%20the%20Visual%20Basic%20on%20my%20Mac%20but%20when%20I%20Click%20on%20%22worksheet%22%20to%20type%20the%20code%20this%20message%20appears%20to%20me%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%22Variable%20uses%20an%20Automation%20type%20not%20supported%20in%20Visual%20Basic%22%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492602%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493575%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710663%22%20target%3D%22_blank%22%3E%40Isabela9%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20give%20us%20a%20clue%20about%20what%20code%20you%20are%20using%20and%20on%20which%20Module%20i.e.%20on%20Sheet%20Module%20or%20on%20Standard%20Module%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493944%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493944%22%20slang%3D%22en-US%22%3E%3CP%3EI%20didn't%20use%20any%20code%20because%20the%20excel%20wouldn't%20let%20me%20type%20anything%20on%20the%20worksheet%2C%20that's%20when%20the%20message%20appears%20to%20me.%3CBR%20%2F%3EDeveloper%20%26gt%3B%20Visual%20Basic%20%26gt%3B%20Worksheet%20%26gt%3B%20The%20error%20appears%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493959%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710663%22%20target%3D%22_blank%22%3E%40Isabela9%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20if%20the%20following%20links%20address%20the%20issue%20you%20are%20having.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelvbaisfun.com%2Fmac-excel-vba-events%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelvbaisfun.com%2Fmac-excel-vba-events%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2F-variable-uses-an-automation-type-not-supported-error-in-visual-basic-editor-in-excel-for-mac-c3125bf3-c30b-4d62-be42-d2f1bec0e5ad%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2F-variable-uses-an-automation-type-not-supported-error-in-visual-basic-editor-in-excel-for-mac-c3125bf3-c30b-4d62-be42-d2f1bec0e5ad%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493966%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493966%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20that%20is%20the%20exact%26nbsp%3Bproblem%20I'm%26nbsp%3Bhaving.%20After%20I%20type%20the%20code%20on%20the%20link%20you%20sent%20me%20the%20error%20stops%20appearing%2C%20but%20what%20do%20I%20do%20after%20I%20type%20this%20there%3F%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-06-27%20at%202.00.58%20PM.png%22%20style%3D%22width%3A%20758px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201693i49DAEFE7A6AC428A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screen%20Shot%202020-06-27%20at%202.00.58%20PM.png%22%20alt%3D%22Screen%20Shot%202020-06-27%20at%202.00.58%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

image.png

 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" 

4 Replies

@Isabela9 

 

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?

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 

@Subodh_Tiwari_sktneer 

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? Screen Shot 2020-06-27 at 2.00.58 PM.png@Subodh_Tiwari_sktneer