Feedback by UserVoice

Crigou

My feedback

  1. 1,465 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    422 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for all your votes and comments about enabling support for UserForms in Excel for Mac.

    With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.

    Please see this article for more information about what you can do in Excel with Office add-ins.
    https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview

    An error occurred while saving the comment
    Crigou commented  · 

    Hi mastige.

    You don't have to switch to Windows, but have it as a complement. That's what an Intel-Mac is made for. What a flexibility with a Mac.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Manuel.

    Here is described, by Microsoft, the Privacy and Security for Office Add-ins:

    https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/privacy-and-security

    It would be interesting to know how other companies adapt their security policy to this.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Jay.

    If you don't like Microsoft, why do you pretend to use their software products ?

    An error occurred while saving the comment
    Crigou commented  · 

    Hi David.

    Thank you for your comment.

    I must admit that you already showed us a usable way on latest November 24th, proposing to make use of worksheet cells (fed by ad hoc vba code) to replace the missing user form controls. You had a good thinking there.

    An error occurred while saving the comment
    Crigou commented  · 

    Screenshot of a programmatically generated UserForm object in Excel for Mac:

    https://stackoverflow.com/questions/50399661/userform-with-excel-2018-for-macos

    What is still needed ?

    An error occurred while saving the comment
    Crigou commented  · 

    Very interesting, what Oliver wrote on May 10th 2017 (soon 4 years !):

    "
    VBA has NEVER been completely portable between MAC/PC. However, this is one of the reasons why .NET has been written for OSX. However, that was only released ~ 1 year ago, and it takes A LONG time to re-write code of this complexity. Those people who think this will be re-written in less than 1 year is kidding themselves. Your best option for now, roll back to Office 2011 for MAC, and use that for the time being.... or run parallels and just run a windows version for the time being. Trust me, when Microsoft is fully compatible with OSX they'll fanfare it. Until then, continuing to complain doesn't get the problem solved (opening a support ticket with Microsoft is your best option for now, with enough support tickets, it will get higher priority to resolution).
    "
    Please consider the full discussion:

    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9098431-bring-back-a-fully-functional-vbe-visual-basic-ed?page=6&per_page=20

    An error occurred while saving the comment
    Crigou commented  · 

    In this recent article on the subject:

    https://spreadsheeto.com/mac-vs-windows/

    one can read:

    " Ideally, you have to use Excel for Windows if you’re a power user. "

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Alfred and Yu.

    You have it on a Mac that is carrying Windows.

    An error occurred while saving the comment
    Crigou commented  · 

    Good thinking Antonio.

    Finally, good news for the famous User Forms topic, that is now five-years old.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Zachary.

    You are asking why UserForm is available for Windows, and not for MacOS. One possible answer is that the two Excel products are developed by two distinct teams, using distinct toolsets, for distinct user communities. Logically, two different things cannot be equal, right ? And if you find the Windows version better, why don't you buy this ? (same selling price). But don't choose the new ARM Mac.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Mike.

    It seems to me that you asked a similar question about one year ago. Then allow me to respectfully ask you another question: if you actually need user forms, how could you live without them during all this time ?

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Oliver.

    Sorry to contradict you, but there are major (and well-known) differences, in MS-Office, between the Windows and the macOS versions:

    https://www.howtogeek.com/340435/whats-the-difference-between-microsoft-office-for-windows-and-macos/

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Dan.

    No reason for you to get so nervous. There is an unexpensive solution to save your 500-hours work: install Windows. I did myself legally download Windows 10.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Wei Liu,

    You are right: the amount brought by each Mac user is the same, but the total amount available to MS for product development is much lower (lower market share of Apple machines).

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Patrick.

    You've asked a good question below:

    " ... I just find strange that they had the user form in the 2011 excel for Mac so it makes one wonder why they did not include it in later versions. ... "

    My answer, according to my own feeling, is that, in the software engineering field, deleting a function assumes less technico-financial effort than continuing to maintaining / correcting / recoding it. Furthermore, in this case, the concerned Mac user has the option to run the most powerful Excel version in Windows, on the same machine.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Lee.
    To follow your last sentence below: Office product managers are considering office-on-mac-users just as important as the income calculated in multiplying number-of-office-licenses-for-mac by price-per-sold-license. Not more important.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Barbara.

    I understand that you are shocked by the surprisingly high price of the uncomplete Office version for the Mac. But we can understand this thanks to simple commercial logic, far from being unfair.

    Assume that, for any reason, Office for Windows and Office for MacOS would be 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.

    Any responsible software developer will develop for Windows first: best performances, best prices.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Heiner.

    It is an illusion to think that the Office version for Mac could become as complete as the version for Windows. This fact is confirmed on the web page:

    https://www.businessinsider.com.au/microsoft-windows-pc-vs-apple-mac-os-2018-5

    where one can read:

    " Microsoft’s Office Suite, which includes apps like Word and Excel, are still best used on a Windows PC instead of a Mac. The Windows version comes with more features and is more stable than it is on the Mac version. "

    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.

  2. 458 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    140 comments  ·  Excel for Mac » Other  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.

    We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.

    Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.

    An error occurred while saving the comment
    Crigou commented  · 

    Hi James.

    You are right, as in this recent article on the subject:

    https://spreadsheeto.com/mac-vs-windows/

    one can read:

    " Ideally, you have to use Excel for Windows if you’re a power user. "

    An error occurred while saving the comment
    Crigou commented  · 

    Hi Gentlemen.

    Has one of you practically tested that this procedure for creating a Data Entry Form is actually not working :

    https://trumpexcel.com/data-entry-form/

    Thanks in advance for your cooperation.

Feedback and Knowledge Base