Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. No forms in VBA what do people do now.

    It was Microsoft who developed the UserForm capability in VBA for Excel and now it is gone - what do people do now.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. Screen Updating in VBA

    It would be great if, as for the Windows version, the Mac version of Excel enables Screen Updating when running a VBA macro. Currently, starting a macro runs but there is no indication whether the application is indeed calculating or simply frozen. adding the command Application.ScreenUpdating = TRUE has no effect

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Easy or even just available data forms for data input on Office 2019

    We just need the basic data forms available to us! UGH it's ridiculous not to have that available and even readily available

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Excel for Mac Macro cannot record data analysis operations

    Excel for Mac's macro cannot record my operations when I use data analysis tools(e.g. using random number generation),but when I do the same steps on windows it can be done.
    Could please fix that
    Details pls follow the link
    https://www.youtube.com/watch?v=x0vygE2JN4o

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. macOS Mojave is only 64 bit update Excel 2011 to 64

    At present if you want to use Forms in VBA you cannot in the latest version of Excel for Mac one has to stay with 2011

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. Mouse cursor disappears after running a macro in Excel for Mac version 16.15

    Need to fix a bug with mac Excel. After running a macro, the mouse cursor disappears. It reappears after typing in another program and coming back to Excel. This fix works sometimes but not all. This gets frustrating. The same macro runs fine in Windows Excel.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. Excel for Mac 2016 does not open xlsm files from Excel for Windows !

    Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

    Excel has a very serious error:
    Do not open the xlsm files maked with Excel for Windows, please correct it... !!!
     
    
I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

    What kind of error is that ???

    PLEASE CORRECT THAT HORROR !!!! ...

    The exact message is the following:

    Notice: 
We have found a…

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Include the shortcuts for Fill commands

    Include the Windows shortcuts for Fill commands

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. Bring VBA on Excel for Mac to parity with Excel for Windows

    Bring VBA on Excel for Mac to parity with Excel for Windows.
    Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

    Why is the not being addressed?

    80 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. screenupdating

    screenupdating = false fails in excel 16.13 again

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. macro options...

    If you select Tools - Macros - Macros... you get a list of macros. Select a macro and click Options... You're then presented with a box that allows you to set a Shortcut key. Either Option+Cmd (for a lower case letter) or Ctrl+Shift (for an upper case letter).

    It doesn't matter what I enter into the little box. Nothing works. No letter, upper or lower case, seems to work.

    Since generally keyboard shortcuts seem to be an issue has this ever worked?

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add the object, property, method help available in Excel for Windows with the F1 key to the Mac 2016 version.

    Add the link to the "msdn.microsoft.com/en-us/vba/excel-vba/articles..." which is available in the Windows version of Excel while using the VBA editor by pressing the F1 key to Mac Excel 2016.

    Thank you.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. VBA bugs

    Hi. Thanks for providing a new VBA editor for Office 2016. I have a vba add-in I've been working on that shortly after some recent updates started having errors pop-up. Please fix Mac Office 2016 so in vba I can close open xlam files.

    In the attached add-in, I install statprogo.xlam, then in the ribbon, I can select, eg, Regression Analysis->Multiple... and then press cancel on the user form to get the error. The workbooks().close call is causing the error when it did not previously.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add the same items in the developer bar as in windows. Many VBA commands are missing, such as insert form

    add the same items in the developer bar as in windows. Many VBA commands are missing, such as insert form

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. User defined functions

    I developed an Excel Add-in that is coupled to a Fortran code in Excel 2016 for Mac. This works perfectly. However, it would be nice if the list of (user defined) functions could be visualised in a separate category or visualised anyway in the "Formula Builder" pane on the right side of the screen (in between the already existing categories and functions). I tried to use

    Sub AddUDFToCustomCategory()
    Application.MacroOptions Macro:="MyFunction", Category:="MyCat"
    End Sub

    but that does not work, nor in my develop Add-in, nor in a very simple Add-In with only one simple function.

    Looking forward to an answer!

    Teus

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. why Excel VBA on mac disapere ? :-( :-( :-(

    a BIG mistake ! (and stupid too)

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. why Excel VBA on mac disapere ? :-( :-( :-5

    a BIG mistake ! (and sutpid too)

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base