According to the Mac BU, future version of Microsoft Office for Mac will have VBA support added back in:
The Mac BU also announced it is bringing VBA-language support back to the next version of Office for Mac.
[...]
The team recognizes that VBA-language support is important to a select group of customers who rely on sharing macros across platforms.