VBA

[fabioribeiro]

I am Looking for a macro that will allow the switching of Tabs in the model every 150 seconds?

Anyone. Thanks

[matt_crowther · Accepted solution]

Fabio,

You shouldn't need a macro.

To get you started:

Create a new Variable (v_Timer) withteh following expresion:

=if(mod(minute(now()),2)=0,1,0)

Then under the Conditional show of Sheet1 enter =v_Timer=1 and Sheet2 =v_Timer=0.

In this case your tabs will switch every minute but it's easy to build from there and alter the variable expresion.

I'd also remove the tabrow to make the application look cleaner...and embeded the whole thing in a PowerPoint presentation via the QVX connector which is ideal for display screens.

Hope that helps,

Matt - Visual Analytics Ltd

New Qlikview Design Blog: QVDesign.wordpress.com