I have just subscribed to Office 365 Home for MAC and am unable to use VBA from developer mode. If I go to Developer mode double click on "sheet" from the sidebar to open the VBA modules then select Worksheet from the dropdown list I get a Message Box as follows

VISUAL BASIC

Variable uses automation type NOT supported in Visual Basic.

As I am unable to proceed past this point I am therefore prevented from coding with VBA .

After searching online it seems there have been very many raising this same problem.

This leads me to think that this may only be a MAC issue running MS EXCEL , therefore I would like to know from the forum that if I purchase a new PC running Windows 7 Pro or Windows 10 are there any members running Office 365 coding with VBA with this setup ?

Regards