Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
Sorry for the delay I have been extremely busy anyway check this link out. look for the reply from Schwieb
I'm on the Office Insider option, but I've had the form option for over a year since Sept last year and it seems to be very slowly getting there hope this helps
It seems that all may not be lost, I hope that this screen shot shows that the Excel team may be working on form.
I was able to make a very basic form and run it however I could not edit it
My Excel ver is 16.27
please see and vote for if possible:-