Feedback by UserVoice

Ken P

My feedback

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ken P commented  · 

    Yes!! Since this is either built in to most UI frameworks, or very easy to implement, it is almost as though the Excel team has put in effort not to do this. This would be a huge boost in efficiency.

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

    We’ll send you updates on this idea

    Ken P supported this idea  · 
    An error occurred while saving the comment
    Ken P commented  · 

    In terms of completeness of macro recording, I would add correctly recording conditional formatting. Specifically, if I apply a conditional number format to a cell (for example, if A1 = "a" then the format for B1 is '#,##0.00_);(#,##0.00);"-"??_);@_)') it works correctly, but when recording the steps the format is applied unconditionally, and there is a line in the macro, ExecuteExcel4Macro "(2,1,""#,##0.00_);(#,##0.00);""-""??_);@_)"")", that fails. This makes no sense to me and should be considered an unacceptable result. Anything that is recorded should be able to be executed, given an identical starting workbook.

Feedback and Knowledge Base