A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dear Oh Soon Keong (M,
Good day! Thank you for posting to Microsoft Community. We are happy to help you.
As per your description, it seems that you are trying to use Macro in Excel iOS app.
If the understanding above is right, we're afraid that there's no out of box way to achieve this currently. For now, macro is only supported in Windows or Mac currently. Sorry for the inconvenience caused.
Personally, I completely agree with you, this is indeed a good addition to the current experience in Excel iOS app. We’d suggest you select your profile picture in the top left, and then select Help & Feedback to send request for the feature to use Macro in app. Feedback submit by this way directly goes to the related team, this is the best way to let Excel developers know your requirements and comments, help improve the product and make it better for you and others.
For your reference: How do I give feedback on Microsoft 365? - Microsoft Support
We've also found some similar requests posted on the Feedback site, please consider voting for the similar ideas in the Feedback Community, your vote will increase the awareness coming from the related team:
Add Macro capability to the app · Community (microsoft.com)
VBA Macros - IOS · Community (microsoft.com)
Macro Excel · Community (microsoft.com)
The Product Team is in-charge of the feedback site, and they are constantly checking the comments and feedback from our customer. Many features have been developed or improved based on users' comment.
Thanks for your understanding and cooperation! Hope you keep safe and healthy always.
Sincerely,
Rhoda | Microsoft Community Moderator