VBA is probably not supported on excel mobile. Office for mac is not currently supported here on QnA. They're actively answering question in dedicated forums here.
--please don't forget to Accept as answer if the reply is helpful--
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.