Solved: Scroll Bar

[Mandy]

Hi

can any one tell me how to add Scroll-Bar into Excel Sheet(ActiveX Control).

Thanks.

[lucas]

If you're adding an activeX spreadsheet to a userform you just need to check it's properties....in the vbe select the spreadsheet and go to view-properties.

look for displayverticalscrollbar and displayhorizontalscrollbar set them to true...which is the default.

[Mandy]

Hello sir

Actually i wanted to add Scroll Bar in the middle of the the Excel Sheet.
Can u tell me how can i add Scroll bar in the middle of the Excel sheet, so that i can program it according to my requirement.

Thanks

[lucas]

You can add a spreadsheet using the control toolbox...it has scrollbars..is the attached what your looking for?

[Mandy]

Thanks sir
but u are not getting my point.
as we add scroll bar in vb6(into a form ) in the same way i want to add a scroll bar in excell sheet.
why i want to do this?
suppose there is a scrollbar having maximum value 1000 and min 0.
i want to change the value of a particular cell, when i move the scroll bar.
the value may be price that may increase or decrease.

so i want to set the value of the a cell through scrollbar.
i hope this will clear the sistuation.


Thanks

[lucas]

You may be looking for a spin button...either way they are both available to the spreadsheet from the control toolbox toolbar.

[Mandy]

if u are taking about option button then i have to add 1000 option button.
??

[lucas]

did you look at the controls available from the control toolbox?

[Mandy]

sory my mistake

let me try spin button
Thanks

[Mandy]

Thanks sir
its working with one line code and setting minimum and maximum value of spinbutton.

[vba]
Price.text=spinbutton1.value
[/vba]

Thanks

[lucas]

Your welcome...be sure to mark your thread solved using the thread tools at the top of the page...