Feedback by UserVoice

Crigou

My feedback

  1. 1,127 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    274 comments  ·  Excel for Mac » Macros and Add-ins  ·  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]

    An error occurred while saving the comment
    Crigou commented  · 

    Let's hope that the future Excel version running on the ARM chip will be better:

    https://www.inputmag.com/tech/how-apples-transition-from-intel-to-arm-chips-will-affect-your-mac-apps

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Joseph.

    To your fundamental and interesting question (why this situation with VBA on Mac Excel), deep explanations are given by Jim Gordon here:

    https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/why-is-excel-2016-for-mac-so-bad/966b5a6a-d81e-4d03-b195-70953cffd275

    Regards and good reading.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi anonyme.

    When you are writing to Microsoft : « ... sino tendré que cambiarme de osx a windows ... « you are just offering them what they expect : a future new Windows user.

    Regards.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi airbear.

    Don't you forget what follows ?

    Assume that, for any reason, Office for Windows and Office for MacOS are two distinct software product developments. And if any MS-Office user would pay for instance 100 $ for it, independently of his platform, then, due to the much lower market share of the Mac users, the development budget for the Mac version would also be lower. This would explain why the wish for identical capabilities cannot be satisfied. Obvious economic reasons.

    Regards.

    Crigou.

    An error occurred while saving the comment
    Crigou commented  · 

    Sorry Will,

    This forum is called " How can we improve Excel for Mac? " and " Using Windows on Mac is a respectable answer too ".

    An error occurred while saving the comment
    Crigou commented  · 

    It is not true that there exists no workaround solution. Because on a Mac one can easily run Windows / Office / Excel / VBA / Userforms as well. Microsoft is not as unfair as it's said..

    An error occurred while saving the comment
    Crigou commented  · 

    OK anonyme, then why don't you contact your seller directly ?

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Patrick.

    Due to the relatively low number of Mac owners needing VBA, it seems logical that, in order to minimize their cost to benefit ratio (like any company, also Apple of course), Microsoft decided not to put more effort for maintaining VBA in the future. And if such a rare user would imperatively need VBA, he can run Windows on his Mac as well. The Microsoft position is commercially defendable, isn't it ?

    Regards.

    Crigou.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi anonyme.

    I can bring an answer to your second question only:

    https://hackernoon.com/taking-office-cross-platform-from-inside-the-windows-company-42c39fa638f5

    Above answer also includes historical arguments. But basically, a cross-platform development can indeed not beat a single-platform development, as far as functional and speed performances are concerned. And the cross-platform development efforts are higher too (complexity). That's what I can tell you in a very first approach.

    Regards.

    Crigou.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Lee.

    Let me logically explain the present situation. Assume that, by 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 users, the development budget for the Mac version would also be lower. This would explain why your wish for "identical capabilities" cannot be satisfied. Obvious economic reasons.

    Regards.

    Crigou.

    An error occurred while saving the comment
    Crigou commented  · 

    Good thinking, anonyme.

    An error occurred while saving the comment
    Crigou commented  · 

    Office / Excel / VBA is broadly not the only Windows professional application that is not running on MacOS. Then Windows on VM should be for a business Mac user a profitable investment in general (a Mac machine is already quite expensive).

    An error occurred while saving the comment
    Crigou commented  · 

    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 ?

    An error occurred while saving the comment
    Crigou commented  · 

    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.

    An error occurred while saving the comment
    Crigou commented  · 

    May be in Excel 2019 ?

    An error occurred while saving the comment
    Crigou commented  · 

    Hi anonyme.

    What you are experiencing was already known about 2 years ago:

    https://www.excelcampus.com/vba/vb-editor-mac-update/

    when Jon Acampora wrote:

    "
    ...

    You can run userforms on the Excel 2016 for Mac. They will just have to be developed in either a Windows version or Excel 2011.

    "

    So bad about Excel on the mac.

    An error occurred while saving the comment
    Crigou commented  · 

    Furthermore, no Extended Support for Excel 2016 / Mac seems being defined:

    https://support.microsoft.com/fr-lu/lifecycle/search/18339

    An error occurred while saving the comment
    Crigou commented  · 

    I just found a discussion

    https://www.quora.com/Why-is-Microsoft-Office-VBA-so-old-and-seems-like-its-never-modified

    in which Microsoft position about VBA on Mac is clearly expressed:

    " … Microsoft glossed over this huge step backwards with the statement that you should be developing code in Windows VBA, and just using the Mac VBA IDE for testing and debugging … "

    An error occurred while saving the comment
    Crigou commented  · 

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

    An error occurred while saving the comment
    Crigou commented  · 

    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.

    An error occurred while saving the comment
    Crigou commented  · 

    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.

    An error occurred while saving the comment
    Crigou commented  · 

    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.

    An error occurred while saving the comment
    Crigou commented  · 

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

    An error occurred while saving the comment
    Crigou commented  · 

    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.

    An error occurred while saving the comment
    Crigou commented  · 

    On this forum

    https://www.excelcampus.com/vba/vb-editor-mac-update/

    Jon Acampora did write what follows:

    "
    ...
    You can run userforms on the Excel 2016 for Mac. They will just have to be developed in either a Windows version or Excel 2011.
    ...

    "
    Better than nothing, isn't it ?

    An error occurred while saving the comment
    Crigou commented  · 
    An error occurred while saving the comment
    Crigou commented  · 

    Another Office 2011 for Mac drawback is that powerful bulk mailing wasn't possible yet:

    https://support.office.com/en-us/article/mail-merge-in-word-for-mac-78583b33-c3c8-4ae8-81e7-d0667c5421c4

    An error occurred while saving the comment
    Crigou commented  · 

    When still using Office for Mac 2011, there are serious and potentially harmful security risks:

    https://docs.microsoft.com/en-us/deployoffice/mac/deployment-options-for-office-for-mac

    An error occurred while saving the comment
    Crigou commented  · 

    On a Mac one can easily run Windows / Office as well.

    An error occurred while saving the comment
    Crigou commented  · 

    Sorry to say that, but a Mac doesn't offer the ideal OS for business (especially lack of software power environment for many professionals):

    https://www.zdnet.com/article/after-30-years-why-did-the-mac-never-break-into-big-business/

    An error occurred while saving the comment
    Crigou commented  · 

    Do leave any Mac OS, and that’s all.

Feedback and Knowledge Base