# Spin button help!!

#### lia

##### New Member
Hi!!

I am novice at spin buttons and wonder if u could help me ...
I have already placed a spin button on cell B14, showwing the selling price of a product and another spin button on cell C27 showing price inflation.
How can I link those two so as a change on the spin button on cell C27 (that will change the price inflation ratio)will reflect immediatly at cell b14???

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
not clear why two spin buttons. one button will do that too anywhere in the sheet
hope you can see a sheet below.
see the sheet below. see new formula in C14. instead of C14 you have it any empty cell.
put one spin button in the sheet.
in design mode right click on spin button and clik properties
in the properties of spinbutton1

max is 100
min is 0
small change is 1

now get out of design mode. as you spin, the value in C27 changes(increases or decreases) by 1 and correpondingly C14 changes

hope I am clear an this is what you want.
=======================

venkat1926 said:
not clear why two spin buttons. one button will do that too anywhere in the sheet
hope you can see a sheet below.
see the sheet below. see new formula in C14. instead of C14 you have it any empty cell.
put one spin button in the sheet.
in design mode right click on spin button and clik properties
in the properties of spinbutton1

max is 100
min is 0
small change is 1

now get out of design mode. as you spin, the value in C27 changes(increases or decreases) by 1 and correpondingly C14 changes

hope I am clear an this is what you want.
====================

Good morning venkat!

I cannot see the sheet that you sent me and I am afraid Ihaven't quite understood your answer.
Could you please try again to sent me the sheet with some more explanation??

The way I'm thinking of it, I'd have a spinbutton for inflation (with the value in one cell) and some other control (spinbutton, textbox, combobox) for the original price. Then I'd put the final price in another cell, calculated by a formula, multiplying the two together.

How's that sound?

(Keep in mind that controls are not really located at cell addresses, that's just the position on the sheet. Some controls have a linked cell, but that only means that the value of the control is displayed in that cell -- the control isn't in or at that cell.)

HTH

Replies
2
Views
1K
Replies
1
Views
513
Replies
1
Views
195
Replies
2
Views
412
Replies
0
Views
255

1,203,515
Messages
6,055,848
Members
444,828
Latest member
StaffordStag

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back