PDA

View Full Version : Solved: Scroll Bar



Mandy
07-01-2007, 09:31 AM
Hi:hi:

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

Thanks.:friends:

lucas
07-01-2007, 10:02 AM
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
07-01-2007, 09:28 PM
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
07-02-2007, 06:01 AM
You can add a spreadsheet using the control toolbox...it has scrollbars..is the attached what your looking for?

Mandy
07-02-2007, 06:11 AM
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
07-02-2007, 06:18 AM
You may be looking for a spin button...either way they are both available to the spreadsheet from the control toolbox toolbar.

Mandy
07-02-2007, 06:22 AM
if u are taking about option button then i have to add 1000 option button.
??

lucas
07-02-2007, 06:23 AM
did you look at the controls available from the control toolbox?

Mandy
07-02-2007, 06:23 AM
sory my mistake

let me try spin button
Thanks

Mandy
07-02-2007, 06:27 AM
Thanks sir
its working with one line code and setting minimum and maximum value of spinbutton. :clap:


Price.text=spinbutton1.value


Thanks:bow:

lucas
07-02-2007, 06:28 AM
Your welcome...be sure to mark your thread solved using the thread tools at the top of the page...