Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I know 3 ref to go to vSheetVisible = 3 , But i know what is 1 ref to what ?
=If(vSheetVisible =1, 2,3)
Paul
Hi Paul,
vSheetVisible is possibly a variable which gets value assigned by a trigger like clicking a button or so. That is, if you click a certain button, it could set this variable value to 1 or 2 or .... (again presumably). And there would be a condition ('Show Sheet') for making a sheet visible or hidden using the same variable.
If you are finding this expression in action trigger for button - it means - if the variable value already set to '1' then set it to '2' else '3'. Hope this gives some idea.
Hi Paul, can you further explain what are you trying? Is this a button to redirect? With which conditions?
Still not clear, can you upload a sample?
Hi Paul,
vSheetVisible is possibly a variable which gets value assigned by a trigger like clicking a button or so. That is, if you click a certain button, it could set this variable value to 1 or 2 or .... (again presumably). And there would be a condition ('Show Sheet') for making a sheet visible or hidden using the same variable.
If you are finding this expression in action trigger for button - it means - if the variable value already set to '1' then set it to '2' else '3'. Hope this gives some idea.
Hi Sir
If i want to go to 8 , i just need to enter 0,0,8 and go there. and i am not able to remove the first 2 zero.
If(vSheetVisible =0,0,8)
Paul