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]Steve Van Dellen commented
On July 23 I posted a comment that, if you opened a workbook with UserForms created with Excel for Windows, the form and controls seemed to work just as they did with Windows and you could edit the UserForm with VBA, again, just as you could with Windows. In that post, I said you couldn't create a new UserForm from scratch with Excel for Mac so you had to have Excel for Windows to get started. It turns out that VBA in Excel for Mac CAN create a new UserForm. https://stackoverflow.com/questions/11519345/creating-form-programmatically-in-the-module-using-vba describes how. I think that code was developed for Excel for Windows but I just copied it into a VBA Module in Excel for Mac and it worked. I haven't done any more with it yet but I don't see why a person can't create any sort of UserForm they like now. Adding Controls and setting all the attributes with code is surely painful compared to doing it visually with the VBE but it does give us a way go forward without waiting for Microsoft.
p.s. Note that you MUST add "Microsoft Visual Basic for Applications Extensions" to the References for the workbook or the code won't compile.Steve Van Dellen commented
If you create a workbook with a UserForm with Excel for windows and then open the workbook with Excel for Mac, it displays the UserForm, the controls all seem to work just like they do with Windows, and you can edit the code in the VBE. The only things missing are the visual editor and the ToolBox so you can't create a new UserForm, change the layout or add/delete Controls. I wouldn't have guessed these were hard to port or re-implement for the Mac.Steve Van Dellen supported this idea ·