Horizontal Bars Scroll-Bars!

Dear Forum,

I am trying to derive the EMI for a Loan Amount and also chart a PIE graph for the same..

Instead of Manually feeding the values such as :

Variable 1 : Loan Amount : Min : Rs 50,000/- Max :Rs 5000000/-
Each Spin (1 Unit) -Rs 25000/-

Variable 2 : Interest Rate : Min : 5% Max : 30%
Each Spin (1 Unit) -0.25%

Variable 3 : Tenure/Duration : Min : 6 months Max : 30 years
Each Spin (1 Unit) - 6 months

I want to have a Scroll-Bar where the values can change Automatically but am not aware of using the same...

Can someone please help me with a small attachment with the above variables attached to it..The values drawn should be displayed as well above the Scroll-Bar and maybe can make the Min and Max more dynamic by storing it somewhere in the Sheet..

I am looking for Non-VBA solution to do the same..

Thanks
e4excel

maybe something like this
alternative in h7 could be
=(G7*6-MOD(G7*6,12))/12&"Y"&" "&MOD(G7*6,12)&"M"

there isn't that much to it! right click it format control and there you go thats your options.

Maybe this
http://office.microsoft.com/en-us/ex...CL100570551033

Hi Martin!

Twice in a day there was a delayed response from my end..My sincere apologies for the same as my new post was posted after your solution and I was completely unaware of your post maybe due to some slag..

Anyways, thanks so much for your help but I made a slight mistake in explaining about the appropriate tool..

I required help on a Scroll-Bar which is a horizontal slider..am genuinely sorry for the trouble Martin..

Can you please help on the same as I did not get the control option for Scroll-Bar...and also can you make it Dynamic?

Guys I have rectified my mistake by changing the Title to Scroll-BAr from Spin Controls I beg your pardon for the same for any inconvenience caused...

Warm Regards
e4excel

there's little difference in the two except scroll bars have a page change increment that controls how much it scrolls if you click between the end slider controls. you cant change these dynamically. for that you'd need one from the controls tool box and appropriate code

whick scroll bar are you using? i used the forms tool bar one.not the controls
one.

Thanks a lot Martin, I never knew this , no wonder it was not working I was referring to a wrong control...

Thanks a lot brother!

isnt that what the horizontal scroll bar on the posted example does? you did say six month increments!
but to go up in months from 6m to 30 years with linked cell as h18
then in another cell
=(H18-MOD(H18,12))/12&" Y"&" "&MOD(H18,12)&" M"
control should be min 6 ,max 360 ,increment 1, page change to whatever increment seems best