Feedback by UserVoice

Crigou

My feedback

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

    We’ll send you updates on this idea

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

    Crigou commented  · 

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

    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.

    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.

    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.

    Crigou commented  · 

    Good thinking, anonyme.

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

    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 ?

    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.

    Crigou commented  · 

    May be in Excel 2019 ?

    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.

    Crigou commented  · 

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

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

    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 … "

    Crigou commented  · 

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

    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.

    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.

    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.

    Crigou commented  · 

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

    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.

    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 ?

    Crigou commented  · 
    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

    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

    Crigou commented  · 

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

    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/

    Crigou commented  · 

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

Feedback and Knowledge Base