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)

716 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]

180 comments

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

    Hi Alain
    I'm on the Office Insider option, but I've had the form option for over a year since Sept last year and it seems to be very slowly getting there hope this helps

  • Alain Thibault commented  ·   ·  Flag as inappropriate

    @Dudley, what IOS version do you have? When I am trying to update Excel the software is saying that I am up to date and my version is of Excel is: 16.16.11.

    How can you be at 16.27?

  • Crigou commented  ·   ·  Flag as inappropriate

    Hi Steve L,

    What is your objection about my comment below ? (June 12th) Or do your agree with the fact that a rich userform is basically incompatible with VBA on Mac ?

  • Steve L commented  ·   ·  Flag as inappropriate

    Hi,

    Really need to be able to use Userforms in the VB Editor on Excel for Mac... Any ideas if this is in development or when it might be released?

    Thanks

    Steve.

  • Crigou commented  ·   ·  Flag as inappropriate

    Hi gentlemen.

    It appears to me today that useful userforms are theoretically impossible in VBA / Excel for Mac. Let's see why. After this source

    https://stackoverflow.com/questions/50144020/overview-of-differences-between-form-controls-and-activex-controls-in-excel

    " Both types of controls can be used on worksheets but only ActiveX controls can be used on userforms. "

    From elsewhere, we also know that ActiveX controls aren't known on a Mac.
    Q.E.D.

  • Mitch commented  ·   ·  Flag as inappropriate

    Do we build websites & databases, or Microsoft Excel's VBA UserForms? It was a decision we had to make.

    I still develop in Excel's VBA. It was the first language I learned to use, 19 years ago.

    I've moved as much as possible to Google Sheets. No VBA support for creating and editing UserForms was the straw that broke the camels back at our company.

    Since my team & I develop in Ruby, Python, and JavaScript, we choose Mac machines for the pre-installed Ruby, Python, etc. for developing the front-end of our websites & databases.

    The internet is pretty popular in 2019. In the USA, more businesses use the internet than Microsoft.

    Microsoft choosing this route, forced us to alternatives. The company is catering to the government(s) sector, that do not have to exchange goods & services for $. Apparently, Microsoft is all in on Asian governments.

    R.I.P.

    Mitch Hunt
    Lead Data Architect

  • David James commented  ·   ·  Flag as inappropriate

    This feature should be added to Excel 2016 as well as newer versions. People who bought 2016 thought they were buying an UPGRADE on 2011 but were scammed. If this is not possible then we should be able to get a FREE upgrade to the current version when it includes the various features removed in 2016.

    Pigs will fly before any of this happens.

  • Robert Frießleben commented  ·   ·  Flag as inappropriate

    You can use instead of VBA and UserForms also JavaScript and HTML in Excel → it is called Office.JS. I suppose, this is the prevered way to implement Userforms in Office 2016 …

  • Tomas Ormeno commented  ·   ·  Flag as inappropriate

    Following the alternative conversation, I would focus on Google Spreadsheets. You have javascript as a language and HTML to build forms :)

  • Ian commented  ·   ·  Flag as inappropriate

    In response to Crigou - yes, Libreoffice does implement equivalent UserForms in its macro language. I have converted all my applications and abandoned Excel for Mac. You can use Python and other languages as well as Basic too.

  • Crigou commented  ·   ·  Flag as inappropriate

    Use Libreoffice instead of MS-Office ? OK, fine. But are we sure to have in Libreoffice something equivalent to UserForms ?

  • Crigou commented  ·   ·  Flag as inappropriate

    Thank you David James, for your good ideas. Now, assume that, unfortunately, for any reason, Office for Windows and Office for MacOS would be two distinct software product developments. And if any Office user would pay for instance 100 $ for it, independently of his platform, then, due to the much lower market share of the Mac machines, the total budget for the Mac version would also be lower. This would explain the "reduced version" evoked by David James.

  • 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.

← Previous 1 3 4 5 8 9

Feedback and Knowledge Base