jmrdigital
New Member
- Joined
- Jul 7, 2016
- Messages
- 7
Hi all,
I've got a spin button going from 1 to 5 with a linked cell. Depending on the number, a pivot will change it's row labels.
To make it easy, if we are at 5 and someone clicks right, I want it to go back to 1 and if it's 1 and someone presses left, it goes to 5. Basically I want a continuous loop.
Can this be done?
Thanks,
John.
I've got a spin button going from 1 to 5 with a linked cell. Depending on the number, a pivot will change it's row labels.
To make it easy, if we are at 5 and someone clicks right, I want it to go back to 1 and if it's 1 and someone presses left, it goes to 5. Basically I want a continuous loop.
Can this be done?
Thanks,
John.