Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

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. PLZ Add Amount in words formula in excel

    PLZ Add Amount in words formula in Excel

    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 →
  2. Some VBA Language Enhancments

    I'm using VBA User Forms intensively.
    What I would suggest is adding

    1) Async-await feature of C#
    2) Task and parallel features of C#

    3) Vba JSON Object

    7 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 →
  3. VBA method to export pictures

    There should be a simple way to export pictures created in Excel. It appears that since at least 2000 we have been able to export Charts but not pictures, which seems very odd. We can cut and past them manual but not automate it.

    I've used "Get and Transform" to automate a whole sheaf of visualisations in Excel ... and now the only way I can send them to anybody is laboriously cut and paste them into separate files and then use Word to create the emails concerned. Or have I got this wrong?

    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 →
  4. Get status of WorkbookQuery (Power Query) in VBA

    Could you please consider possibility to add new property to object WorkbookQuery, that return status of query result. E.g. "N rows loaded", "Load to Data Model failed.", "Connection only".
    Currently I do not see option to catch query refresh issue in VBA.

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

    We’ll send you updates on this idea

    6 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Adding an UNDO feature to Excel VBA

    Hey There,

    There is no doubt that VBA is offering great solutions for companies and individuals. I have been working on VBA extensively for a year and the only thing that is still illogically unresolvable is the UNDO feature to VBA Excel.

    I would really appreciate it if it possible to point out why it is not possible to add such a thing to EXCEL VBA.

    Thanks in advance.

    12 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 →
  6. Try...Catch...Finally Statement for VBA

    Please provide VBA with the Try...Catch...Finally Statement.

    The VBA really needs this statement.

    9 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 →
  7. Add a shortcut for incrementing variables (VBA)

    The option to use variable++ as an equivalent to variable = variable + 1 would be very handy, I think.

    6 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 →
  8. Inquire Add-In that will work with Excel 2016 Professional, not only Pro Plus.

    Provide a download for the Inquire Add-In that will work with Excel 2016 Professional, not Pro Plus.

    4 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 →
  9. vba userforms

    Please provide more controls on forms to improve its look and feel. 3D effects, animations on buttons, table formatting in text boxes, etc

    16 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. Add ProgressBar control in VBA forms for Office 2016 64-bit

    Is it possible to have a workbook that uses the ProgressBar control
    from mscomctl in 32-bit Excel, but does not use it (and does not give
    the user an error) in 64-bit Excel? Currently when I open the workbook in 64-bit Excel, I get an error that it can't find the library.

    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 →
  11. vba code navigation

    Please add 'cross references' in the code for navigation. e.g. where a function/sub is called, if the user doubleclicks or crtl+clicks on the function/sub then they get taken to it

    5 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 →
  12. Unique instances of excel please....

    ...without having to do this...press Windows+R (Run), then type “Excel /x” without quotes. This is not efficient

    4 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 →
  13. 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 →
  14. Bring back calendar control as a vba reference

    Excel 2007 supported a calendar control reference that allowed the programming of a pop-up calendar for date pick on worksheet_change. This function has been stripped from newer version of excel. The convenience of this reference can't be overstated, and ensures correct date format.

    8 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 →
  15. Fix Application.WorksheetFunction.Match

    For decades Excel's Application.WorksheetFunction.Match has had return type Double, as shown in the VBA object browser. This means it throws runtime errors when there's no match for its 1st argument in its 2nd argument rather than returning an error value (#N/A).

    Since Application.Match does work more as nearly all users would expect, is there some reason Application.WorksheetFunction.Match can't work exactly the same as Application.Match? If not, why can't Application.WorksheetFunction.Match work exactly the same as Application.Match?

    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 →
  16. VBA Programming language lacks syntax for sorting and compressing 2 dimensional array variables

    Sort arrays both single and two dimensional as well as being able to groups and sum array elements. As arrays run 20x faster than normal VBA code this would make programming fast running macro's much easier.

    6 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 →
  17. There should be a Worksheet.RowCount and Worksheet.ColumnCount properties that tell you what the last row or column with data is

    There is no good way of finding the last row or column with data in a worksheet.

    Three ways are of finding the last row or column are:
    1) used Worksheet.UsedRange. The problem with this is that if some of the cells in the range have had their contents cleared or deleted then they are still considered in the UsedRange. this means that the bottom-rightmost cell in the UsedRange may not have any data in it and cannot be accurately used to get the row or column count for the worksheet.

    2) Using range.end(xlup).row or range.end(xltoleft).column only works for a…

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

    We’ll send you updates on this idea

    8 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. VBA Forms not working in MS Office 365 ProPlus version 17.0

    VBA Forms not working in MS Office 365 ProPlus version 17.0 which got released recently on May 9th, 2017. The Macros are getting crashed throwing the error 1004: Application-defined or object-oriented error. Until Version 16.0, Macros worked fine.

    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 →
  19. Create 64-bit compatible versions of MSComCtl and MSComCt2 controls

    We have been advised to consider upgrading to the 64-bit version of Office throughout our company. As a world leading financial institution we have a lot of users that use Excel applications that require large amount of memory and processing power.

    We have a dedicated VBA development team that make extensive use of the controls and we need 64-bit versions of the controls before the roll-out can go ahead as a large number of critical applications will no longer work in 64-bit Excel.

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

    We’ll send you updates on this idea

    27 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. DON'T use Python as an Excel scripting language

    DO NOT let us do scripting with Python! Yay!

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base