topic VBA in QlikView https://community.qlik.com/t5/QlikView/VBA/m-p/300173#M111162 <HTML><HEAD></HEAD><BODY><P>I am Looking for a macro that will allow the switching of Tabs in the model every 150 seconds?</P><P></P><P>Anyone. Thanks</P></BODY></HTML> Tue, 24 Jan 2012 01:06:47 GMT fabioribeiro 2012-01-24T01:06:47Z VBA https://community.qlik.com/t5/QlikView/VBA/m-p/300173#M111162 <HTML><HEAD></HEAD><BODY><P>I am Looking for a macro that will allow the switching of Tabs in the model every 150 seconds?</P><P></P><P>Anyone. Thanks</P></BODY></HTML> Tue, 24 Jan 2012 01:06:47 GMT https://community.qlik.com/t5/QlikView/VBA/m-p/300173#M111162 fabioribeiro 2012-01-24T01:06:47Z VBA https://community.qlik.com/t5/QlikView/VBA/m-p/300174#M111163 <HTML><HEAD></HEAD><BODY><P> Fabio,</P><P></P><P>You shouldn't need a macro.</P><P></P><P>To get you started:</P><P></P><P>Create a new Variable (v_Timer) withteh following expresion:</P><P></P><P>=if(mod(minute(now()),2)=0,1,0)</P><P></P><P>Then under the Conditional show of Sheet1 enter =v_Timer=1 and Sheet2 =v_Timer=0.</P><P></P><P>In this case your tabs will switch every minute but it's easy to build from there and alter the variable expresion.</P><P></P><P>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.</P><P></P><P>Hope that helps,</P><P></P><P>Matt - Visual Analytics Ltd</P><P>New Qlikview Design Blog: <A href="http://QVDesign.wordpress.com">QVDesign.wordpress.com</A></P></BODY></HTML> Tue, 24 Jan 2012 10:09:03 GMT https://community.qlik.com/t5/QlikView/VBA/m-p/300174#M111163 matt_crowther 2012-01-24T10:09:03Z