How to Change Excel Report Views from a Drop Down List

Поділитися
Вставка
  • Опубліковано 27 жов 2024

КОМЕНТАРІ • 7

  • @Up4Excel
    @Up4Excel  3 роки тому +1

    📗 Free template with vba code: »» cutt.ly/up4v2013MFD
    🎯 Custom report and data views in an instant....Choose what's hidden and what's not from a dropdown list of different spreadsheet views. Different people want to see different things on your spreadsheet…let them choose the view they want from a dropdown list.
    👉 Up4Excel Downloads Library: »» ml.up4excel.com/library

  • @wayneedmondson1065
    @wayneedmondson1065 3 роки тому +1

    Nice one John! Thanks for sharing this technique and the workbook and code. Thumbs up!!

    • @Up4Excel
      @Up4Excel  3 роки тому +1

      Thanks Wayne, hopefully something of use to you in the 👍

  • @hero7593
    @hero7593 3 роки тому +1

    You are doing extremely well keep it up

    • @Up4Excel
      @Up4Excel  3 роки тому +1

      Thank you, I will certainly try 👍

  • @anneschwendinger2631
    @anneschwendinger2631 2 роки тому +1

    I am trying to implement this but I struggle at the step where the code is implemented into the ComboBox. I am not too familiar with VBA, can exactly the same code as used in the video be used or are there certain parts that need to be changed? (Except obviously the names of the different views). It doesn't do anything with my toolbox, any recommendations how to fix this?

    • @Up4Excel
      @Up4Excel  2 роки тому

      I don't see an obvious reason why you couldn't use the exact same code Anne...get it from the free workbook download in the video description. On your toolbox issue, it might be your macro settings so have a look at them in the options menu, other than that I'd try a PC reboot - it's amazing what that can solve.