How to Fix “Variable uses an Automation type not supported" Error in VBA Editor in Excel for Mac
In Excel for Mac there's a bug in the VBA Editor that prevents you creating "event-driven macros".
When you click the drop-down arrow at the top of the code window and select Workbook or Worksheet, you get the following error:
"Variable uses an Automation type not supported in Visual Basic"
This error has been present since a new VBA Editor was introduced in 2017!
In this video I'll show you 3 workarounds and provide you with a file that contains all you need to get round this roadblock
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:28 What was the error?
00:01:49 The workarounds
🗒 Notes and Resources
Download a copy of the file used in this video: https://share.getcloudapp.com/2Nu7gW91
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #mac #vba