Enable VBA Support for creating and editing UserForms (not the Data Form)
In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.
(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)
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]
Although new to VBA and user forms I was quite disappointed to discover, after upgrading, that this feature was not available.
David Barber commented
I was considering buying office 365/2016 and cannot justify it without VBA. Most of my work colleagues use Macs and I heard from them there may be a problem, as he has;t upgraded yet either! We work on Macs as we are mobile, but have several thousand windows based PC's. Head office have even mooted Linux, although they went from XP to Win 7 recently; they installed Open Source Office (KingSoft) and may be moving to Open source fully on the intranet. There's now a reminder that my shopping cart is waiting, but there's not feedback to let them know why I'm not buying!
David Barber commented
i really shouldn't have to pay for a PC and Windows for VBA functionality on my MAC. You should perhaps call it "Mac Office Lite" and be specific about the lack of features.
tyler durden commented
how can i use userform in Excel 2016 VBA?
Jon Peltier commented
Microsoft has clearly stated in many places that the VB editing capabilities in Mac Excel 2016 are still under development. I don't like the VB Editor in Mac Excel 2011, so I do all my VBA work in Windows, then just use Mac Excel 2011 and 2016 for testing and debugging, and implement any changes needed in Windows.
The 2016 beta version that I have tested has no Userform feature in its Developer. I would have to use the 2011 version when I need to produce a file with VBA Userform. Pls make sure that also 2016 version has Userform feature in its VBA Developer. Thanks