Slow response time when using VBA goal seek

Hi all,

For my project, I've input simple VBA code to automatically goal seek whenever changes are made to the specific cell. (detail spreadsheet can be found in the attachment).
Everything work well, means "result cell" will automatically re-update within second after I change "input cell".

Issue come arise when I start to add chart (sheet Trial2) to visualize new value where slow response time were noticed when I change "input cell".
(INFO: I use Y-error bar for creating pink line in the chart)

It doesn't mean that "result cell" stop re-updated, in contrary, it work fine but it's seems that there is some delay time for excel to response when I click other cell after I change "input cell".

Can someone help me how to solve this issue ? or maybe there is an error in my code that make this delay in response ?


B'rgrds

Hendra

Hello Hendra,


It looks like you may be experiencing a chain of Workbook events. You could try disableing events in your code. You originally had this:

Please Login or Register  to view this content.

Try this instead:

Please Login or Register  to view this content.

Good luck!