Need help creating scroll bar in Excel 2007

[prakashseth]

Hi friend i am new to excel 2007,I need help with creating a scroll bar using either form or activex control. The problem is create a scroll bar to put values from 9000 to 90000. maximum it goes is 30000.

thanks in advance.

[chroma]

HI

If you right-click on the ActiveX scrollbar, then choose Properties,you will see various properties you can change on the object - including "Max". Change the Max value to 90000 and the Min to 9000 and you should be all set.

Also, if you want to be able to scroll down faster, set the Small change to 1, but set the large change to something higher (e.g. 90).

[Soumen]

After I set that what do I put linked cell to ? When I set max to 90000 and min to 9000 and click out, nothing happens. The scroll bar is still highlighted. I see =EMBED("Forms.ScrollBar.1",""). What do I do ?

[chroma]

Set your linked cell to the cell you want to hold the current value of the slider (optional, but seemingly necessary if you plan to use it to increment something on your worksheet).

Nothing happens after you set the Min and Max because you're still in 'Design' mode. On the Visual Basic toolbar (Developer ribbon tab -> Controls section) click the 'Design Mode' icon to exit Design mode. That will allow the scroll bar to work normally.

[Soumen]

I got it. Thank you. Appreciate your help!!