Feedback by UserVoice

How can we improve Excel for Mac?

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)

717 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

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]

181 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • David James commented  ·   ·  Flag as inappropriate

    It has to be said that the main reason why Apple never had a larger share of the market was due to the simple fact that their own versions of Office (and other software) were toys compared with the real thing. Microsoft has always had a strong commercial following and it could easily “command” the Apple community as well by making the full version of Office available “on a Mac “. Not doing so encourages Apple users to use software such as OpenLibre which has a macro facility - not wonderful but better than what MS are offering at present.

  • Crigou commented  ·   ·  Flag as inappropriate

    OK, but on his side, a wise boss, naturally pragmatic, and actually needing full VBA on Mac, would never give up to also run Windows on that Mac, only for personal anti-Microsoft ideological reasons. MS know that, too. Then no many professional customers are lost in the game.

  • David James commented  ·   ·  Flag as inappropriate

    I agree - profit is the driver in any organisation - but not at the cost of losing custom. This feature is central to the way Excel is used by many companies and Microsoft will lose custom on this one.

  • Crigou commented  ·   ·  Flag as inappropriate

    Fortunately, most complaints in these discussions aren't of professional nature. As a matter of fact, any responsible boss wouldn't accept to wait several years for a workable solution with VBA.
    Crigou.

  • Crigou commented  ·   ·  Flag as inappropriate

    All what is undertaken by any company (Microsoft, Apple, …) is deliberate and guided by cost / benefit minimizing.

  • David James commented  ·   ·  Flag as inappropriate

    It's been three years... I think the reason is either

    1. Microsoft deliberately down grade software designed to run on Apple equipment
    2. Microsoft are incapable of producing a version which runs on Apple equipment
    3. Apple have made it difficult or expensive to to make this happen
    4. Microsoft want you to buy the 365 version and make money on the license fee
    5. other (you choose your favourite conspiracy theory)

    The bottom line is Microsoft are charging full price for a crippled version not much better than Apple's Numbers (which costs a whole lot less). Microsoft are clearly not interested in its customer's requirements.

  • Crigou commented  ·   ·  Flag as inappropriate

    It’s now for longer than three years that the present discussions have taken place.

  • Brian commented  ·   ·  Flag as inappropriate

    I will return office in the next 30 days if this feature isn't added back.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please get via user forms back. I bought office for Mac just to get back working with excel via. I really need this feature. Thanks

  • Patrick B. commented  ·   ·  Flag as inappropriate

    I'm so irritated to find this function mysteriously missing. Please add userforms back.

  • Crigou commented  ·   ·  Flag as inappropriate

    It is not true that LibreOffice is quite free. On their web page, they wish us to donate some money:
    https://www.libreoffice.org/donate/
    Nothing is free in our economic system: the LibreOffice developers also have to finance the numerous working hours.
    Crigou.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I have a new MBP running 14.14.2 I also have Office 16.21 (181219). If I go to the VB editor I have a basic Use Form it does not run very well at present but it is there see also https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_365hp/userform-for-mac-2016/74bd553f-4d13-4724-82c1-c707fbfdb900?messageId=c00a6831-2e8d-43a9-a5d4-e5a280ba9410
    I do NOT work for MS but do you VB extensively I'm sure its on the way back (Please Please )

  • Jan commented  ·   ·  Flag as inappropriate

    I think the UserForms is coming, but there are some troubles. If they accidentally published it, it exists. Of course it is not a guarantee. MS removes working pieces from Windows products also. Such as they removed VB from Office Powerpoint years ago just to come back with it later..

  • David James commented  ·   ·  Flag as inappropriate

    Well done - congratulations you have joined the growing army of Microsoft independents! MS really do need to reconsider their policies or they will continue to loose custom to other software developers.

    I moved to Apple and then to Linux (because Apple doesn’t have adequate “Office” software) and now use LibreOffice.

  • Ian commented  ·   ·  Flag as inappropriate

    I gave up and converted all my macro-enabled spreadsheets to LibreOffice. A bit of work to learn the new interface, but it all works, including the equivalent of Userforms, and its all cross-platform - Windows, Mac and Linux. And its free!

    Ian M

Feedback and Knowledge Base