Spin button help!!

[lia]

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???

Please Help!!!!!!

 

[venkat1926]

have I understood your query?
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

linked cell is C27
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.
=======================

*removed by Admin*

 

[lia]

have I understood your query?
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

linked cell is C27
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??

Thanking you in advance

 

[Tazguy37]

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