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]jgm commented
Please bring back the data entry form in excel 2016 for mac.
We are glad to announce that the first phase of the project is available for Insiders Fast. At this stage we support refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
We have exciting times ahead of us!
- Excel Team
This suggestion is from quite a while ago and we’ve had lots of updates since then. Please comment whether this is still an issue or let us know that it’s gotten better. We’ll keep this open and monitor for votes and comments.
Steve K [MS Excel]