A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Autocomplete is not currently in the VB Editor for Office 2016 for Mac. Microsoft will be adding this functionality. A date has not yet been announced for this. I keep hoping with every new update that the new VBE will be in it, but so far, no luck. You can vote for and comment on this topic here:
Bring back a fully functional VBE (Visual Basic Editor for VBA)