Make a spinner control SELECTED cell

[downward spiral]

I have a worksheet with many numbers that need to be changed often. Instead of making a separate spinner for each cell is it possible to make just one and have it +1 or -1 from the cell I have selected?

I was thinking there's probably something I can input in the "cell link" box to do this.

Thanks

[Bryan Hessey]

I have a worksheet with many numbers that need to be changed often. Instead of making a separate spinner for each cell is it possible to make just one and have it +1 or -1 from the cell I have selected?

I was thinking there's probably something I can input in the "cell link" box to do this.

Thanks

Hi,

if you used the Spinner from the Control Toolbox, set the Linked cell, then Rightmouse and View Code and put

Please Login or Register  to view this content.

where 'H8' is your linked cell


hth
---

[downward spiral]

I see what you're saying, but instead of setting my value change to cell H8, can i change H8 to something general like "highlighted cell" ?

I want one up button and one down button to be able to add or subtract from whichever cell i highlight in the worksheet



EDIT:

Here's what my worksheet looks like. I have 6 columns.

Number of Units | Unit Name | Unit Price | Units Sold | Units Not Sold | Units Currently in Auction |
______20_________thing_______$10_______10___________25________________5_____________

[downward spiral]

so nobody knows if this is even possible?

[Bryan Hessey]

I see what you're saying, but instead of setting my value change to cell H8, can i change H8 to something general like "highlighted cell" ?

I want one up button and one down button to be able to add or subtract from whichever cell i highlight in the worksheet



EDIT:

Here's what my worksheet looks like. I have 6 columns.

Number of Units | Unit Name | Unit Price | Units Sold | Units Not Sold | Units Currently in Auction |
______20_________thing_______$10_______10___________25________________5_____________

what DO you mean by 'highlighted' cell?

do you mean the currently selected cell?

did you test the code?

As you can 'highlight' more than 1 cell only the defined 'Active cell' will increment.

also, what your worksheet looks like is not correctly represented here, if you need to show then please attach a zip'd sample sheet, then the helpers do not need to type up your data.

did my code work? - if not in which way did it not work?
---

[Bryan Hessey]

so nobody knows if this is even possible?

I guess the answer to this would be for you to link the spin button to 'ActiveCell' - - and if you find a way to do that please let us know.

---

[downward spiral]

got it!

[Bryan Hessey]

got it!

good to see, and thanks for the feedback.

---