Reset Button

[agoo20]

Hi, I created a spin button that allows one to increase or decrease interest rates.

I am trying to create a reset button that would reset (not clear) the interest rate back to its original starting value.

Can anyone help me out on the code for the button? I know how to create the button, but I do not know much about coding. I will attach the spreadsheet.

[watersev]

hi, agoo20, please check attachment

[jaslake]

Hi agoo20
Perhaps this

Please Login or Register  to view this content.

[agoo20]

hi, agoo20, please check attachment

Watersev thanks for the reply. The code worked, but I was wondering if you could tell me how the code knows which cell to reset since there is no specific mention of "C3" in the code?

I took the code and tried using it on a spreadsheet with a lot of adjustable values but it came up with a debugging error for .value = .min.

Thanks so much!

[agoo20]

Thanks jaslake the code worked.

[watersev]

@agoo20
The code provided uses index value of the shape, you can use spin control name instead to work precisely with particular one. The connected cell is set in it's format options.
Another option offered by Jaslake is not the one I would go for, because it is referencing a cell and setting some value. In case you will amend spin button options you will need not to forget to change range and value.
While using my code with name of the control you may change cell reference and min value in control format and it will work as expected.

[watersev]

to support what I'm talking of, the connected cell is moved to a different cell the code would work because it works on control object level without changes required to Reset button code.

[agoo20]

Watersev, thank you for clarifying this. I created a new spin button and changed the code you provided to reference the new spin button name and it worked perfectly.

Thanks so much!

[watersev]

if you are happy with the offered solutions, please mark the thread as Solved (see Forum Rule on How to questions: http://www.excelforum.com/forum-rule...rum-rules.html, rule #9