selection calculation time

[#1]

Hi All,

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.

Regards

[Clever_Anjos]

Immediatly after the selection

Check Sheet Properties / Sheet Objects

[#3]

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??

[sujeetsingh]

Sorry it may be done through the macro Script

[#5]

Do you have any ready sample available??

[Clever_Anjos]

here is the code you need

set s0 = ActiveDocument.GetSheetObject("CH01") ' your sheet object

t = so.GetObjectCalcTime

msgbox(t)

[Clever_Anjos · Accepted solution]

PFA