A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Dear Sumanth,
Based on my experience, VBA code can only be written in Excel 2016 for Mac. However, as the question is if users can use Visual Studio for Mac to write VBA code of Excel 2016 for Mac and we have a dedicated platform for Visual Studio for Mac related issues and questions, I suggest you post a new thread on our Developer Community-Visual Studio for Mac to get a clear answer and expert help.
Best Regards,
Cliff