LinkBack URL
About LinkBacks
Hi I need to have one spin button to control multiple cells of my choice i.e. the one selected, rather than use 100+ spin buttons. Is this possible???
Hi I need to have one spin button to control multiple cells of my choice i.e. the one selected, rather than use 100+ spin buttons. Is this possible???
Don't think you can... but could you not make all the other cells equal the cell the spin button is linked to? For example make the spin button control A1, and then "=A1" in all the other cells?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Oh oops, you mean control only the active cell?
Yes I want the spin button to only control the active cell
Last edited by ieuandavies; 05-01-2015 at 01:34 PM.
Yes I want the spin button to only control the active cell
SOLVED!!! I type my own code for the sheet and now its working fine, thanks for the help anyway
Hi,
See the following code (using a Forms Spinbutton which is included in the attached file.
In an ordinary code module such as Module1:
Lewis
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks