Does anyone know any way to calculate the time that a specific selection took for a selected chart??
For example when I select a country from a list box I want to know how much time it took for the chart sales per country (green progress bar) to get calculated.
Immediatly after the selection
Check Sheet Properties / Sheet Objects
I know that you can check the calculation time of each object. I was just wondering if there is a way to retrieve that statistic and show it on a text box??
Sorry it may be done through the macro Script
Do you have any ready sample available??
here is the code you need
set s0 = ActiveDocument.GetSheetObject("CH01") ' your sheet object
t = so.GetObjectCalcTime
Retrieving data ...