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. allow for does not equal for auto-filter, when inserting into VBA

    Hello.
    Over the years, I've found that I needed a filter, which I could modify, using VBA, that would allow me to filter more than a single component when I'd activate it. Last year, I posted on the MSDN-Excel for Developers forum, and one member gave me a sample which I modified, and got to work for my purposes.

    https://social.msdn.microsoft.com/Forums/en-US/2e738c1e-ca46-4511-8d93-4ba870468aea/multifilter?forum=exceldev

    I took his sample, made the changes, and now have an excellent filter tool (I posted my final solution, and have made several using different numbers of components), and thanks to VBA, I can add, remove, increase, reduce, etc... my…

    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 →
  2. Range.Value and Range.Value2 should work for non-contiguous ranges

    Range.Value and Range.Value2 will return the values of only the first area in a range if the range has multiple areas.

    If you are using, for example, SpecialCells to get the visible cells in a range, the range can have multiple areas and we should be able to use Range.Value and Range.Value2 to get all the visible cells values as an array instead of just getting them for the first area in the range.

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

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Before Copy, Before Paste, After Copy and After Paste events

    Excel needs these events - before copy, before paste, after copy and after paste events to be added to the standard worksheet events. It is possible to do this with custom events and using the windows API to query the clipboard, but it is unreliable. They are necessary to be able to control how users interact with a spreadsheet that is locked down

    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 →
  4. The function VBA.Format should be part of the Excel object model and not only the VBA language

    The Format (or VBA.Format) function is part of the VBA language, not the Excel object model. This means that this function is not available to .NET COM addins (VSTO, AddinExpress, Excel DNA). This can be a problem for the development of new addins using .NET or upgrading existing VBA addins to COM.

    Note that .NET has string.Format() and Microsoft.VisualBasic.Strings.Format() but neither of those has the same behavior as the VBA Format function especially with regards to dates.

    Note that there is a similar function that is part of the Excel object model: WorksheetFunction.Text(). However, this function still differs from the…

    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 →
  5. [VBA] Shape color is not visible with Excel 2016, but is with Excel 2013

    I've made a code for studying function SIN and COS. It's like an analog clock that shows only second hand(Line shape).
    It works as expected with Excel 2013. But with Excel 2016, second hand(colored red) cannot be seen, only marks(both ends of Line) can be seen.
    I've reproduced this, in Windows 7, 8.1, and 10.
    --- my code ---
    ' --- for "Sleep" スリープ関数(API)の宣言
    Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

    ' ---[10] Analog Clock (display second hand) (アナログ時計・秒針を表示:サイン、コサインの練習)
    Public Sub prcShowAnalogClock()

    Call prc_Clear_Clock    ' -- delete Oval and Line already exist: 既存の円と直線を削除
    
    Application.ScreenUpdating = True
    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. Allow modifying custom ribbon controls using VBA

    It would be very helpful to have the ability to edit custom controls using VBA (such as in Project with method SetCustomUI(CustomUIXML)). Sometimes it is necessary to add or remove controls (nut just show and hide).
    Thanks!

    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 →
  7. Macros usable to other users

    When you create a macro and send the workbook to other users, unless they have their settings such that they can run a macro, you need to give them special instructions so that the macro runs.
    Surely, there must be a way to send a workbook with a macro in it to someone without having to tell them to change their security settings which often causes them to think they're doing something to put them at risk.

    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 →
  8. The ability to make macros that use functions like Solver

    The ability to make macros that use functions like Solver

    2 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 →
  9. 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 →
  10. Allow Edit of the Macro Button

    Allow users to edit the Macro Button (like we could in an older version of Excel) for custom macros in the Quick Access Toolbar. Currently, we can select from ~180 images but it was so much nicer when you could go in and 'draw' your own button.

    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 →
  11. 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 →
  12. 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 →
  13. Fix the interaction between macros and Power Pivot/Power Query

    If you have any personal macros (or even a macro worksheet in your XLSTART folder), PowerPivot and Power Query both break—it's been a big bummer having to get rid of all my old macros to use my data models.

    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 →
1 2 13 14 15 17 Next →
  • Don't see your idea?

Feedback and Knowledge Base