Feedback by UserVoice

How can we improve Excel for Mac?

Restore data form functionality (different from VBA UserForms)

I miss the data form feature available in previous versions of Excel and would like to see it restored in Excel for Mac. Note that the Data Form feature is not the same as VBA UserForms. There's a separate suggestion if you want to vote for VBA UserForms.

211 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jim shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    We will still accept votes on this suggestion. Please note that this suggestion is not for VBA UserForms. There’s a separate suggestion you can vote for if that’s most important to you.

    Some comments on the other suggestion indicate that clarification was needed, so I’ve updated the titles and description to be clearer.

    Steve K [MS Excel]

    29 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Let's make a strong current for Excel 2016 on the Mac to be updated with the use of forms. It is very difficult to work like this. Can anyone shed some light on the subject ?: What does Microsoft talk about?
        We buy the Microsoft product also when we use MAC. Please. Look at MAC users.

      • Sherry Carter commented  ·   ·  Flag as inappropriate

        You have just caused me merciless heartache with my boss. I work as his personal admin, he uses only macBooks and I am in a learning curve and you have made this so hard. I am going back to Windows and he will have to download Windows for mac. Please provide what we need... I . need a fast Userform application.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I need tu use VBA on my Mac. Please fix it, I think in turning back to windows then :/

      • Michael commented  ·   ·  Flag as inappropriate

        Please bring back DATA FORM feature. It's impossible to enter data without it.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I am out of words really. Now I am stuck with this ****** 365 I can not use as intended. Please fix. Soon.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Seriously!?!?!?!?!? Why on earth did MS eliminate this feature?!?!?! What Mickey Mouse Jack
        A$$ approved this?!?!?

      • Anonymous commented  ·   ·  Flag as inappropriate

        if MS decided to remove the UserForms in the 2016 MAC version, shouldn't it make a logical sense to provide an alternative or newer method to create forms, instead of just removing it and with no other means..? But then again we are talking about MS... logical sense? Whats that!!

      • Anonymous commented  ·   ·  Flag as inappropriate

        Need "user form" back in Mac excel 2016. The removal of this command is nothing less than STUPID.
        May get rid of Excel and goto Numbers for Mac.

      • David James commented  ·   ·  Flag as inappropriate

        Simon queries why we have to continue with paying for new version of MS which are incrementally worse than the previous - a payment for downgrading. You don’t have to - you can move to the OpenOffice suite - it’s free, runs on most OS’s and has a macro system similar to MS’s. the only down side is that it is not exactly compatible with MS VBA and there is a steep learning curve. I think the wise move is not to upgrade MS Office until they sort it! This may take a long time......

      • SImon commented  ·   ·  Flag as inappropriate

        Why are we paying for Microsoft to make excel useless in increments? first VBA and now forms and many more. discuss....

      • Sam commented  ·   ·  Flag as inappropriate

        This is really sad that Microsoft do not say anything regarding these changes. I got office 2016 while ago I have so many Excel applications that use user form almost all of them now none of them works in this **** version. The **** with Microsoft office.

      • David James commented  ·   ·  Flag as inappropriate

        In Excel 2011 for Mac the Form icon is available by right clicking on the quick access toolbar (at the top) and choosing "Customize Toolbars and menus..." then select Data in the left column and "Form..." in the right which can be dragged up onto the toolbar.

        In Excel 2016 for Mac it is not available. The quick access toolbar customization is in Preferences, but the Form icon has been deleted.

        Why Microsoft feel they need to firstly change the method of finding these controls and then deleting some is beyond my comprehension. My motto has always been "if it ain't broken DON'T FIX IT"!

      ← Previous 1

      Feedback and Knowledge Base