Nov 26 2017
09:05 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
Nov 26 2017
09:05 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
I'm trying to set up a macro that either adds or subtracts 1 from the value of a cell when I click on spin button. (Obviously, add 1 when I click the up button and subtract when I click the down button)
Dec 18 2017 07:33 AM
Christopher,
According to below screenshot, you have two options:
To find them, go to Developer Tab >> Controls Group >> Insert.
ActiveX SpinButton is more flexible, it can come down to negative values.
I linked the first one which is SpinButton (Form Control) to cell E4, but the second is linked to the active cell.
I've attached the solution for you.
Aug 27 2019 04:29 PM
Aug 27 2019 08:41 PM
Hi,
The SpinButton (Form control) can only go up and down! This is one of its limitations!
But the ActiveX version is more flexible as you can drag the sizing handles of the SpinButton to make it show up horizontally (Left/Right) or vertically (Up/Down) based of its height and width.
Go to Developer tab >> press Design Mode, then try to resize the SpinButton (ActiveX) in a rectangular shape and see how it's orientation will change to horizontally (Left/Right).
Regards