• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Listbox and dashboard speed

Y

ysherriff

Member
To all,

I created a dashboard that utilizes a drill down listbox but the macro is causing the speed of the dashboard to go extremely slow. Can anyone help with suggestions on how to optimize the dashboard for quicker calculation? I tried using ApplicationScreenUpdating and it doesn't work.

This is a rather complex dashboard and any help is greatly appreciated. The code for the listbox is located on sheet12

If there are other optimization techniques that I can use. I am always a student of learning. below is the link

https://www.dropbox.com/s/2p8yht5sq...ne Performance Report v1.5- formula.zip?dl=0
 
after further review, I do not believe it is the listbox. I believe my calculations are slowing the dashboard. I will move this discussion to another forum.
 
You must log in or register to reply here.
Back
Top