Create a scroll bar

[Brian from Maui]

Ihave a request from a freind who wants a create a scroll bar in S3 and have it scroll right from column S. Is this possible. He has what seems like a scroll bar, but the sheet doesn't scroll.

 

[Ivan F Moala]

Hi Brian
Can your friend not use the std scroll bar within Excel @ Bottom ?
What type of scrollbar, ToolBox or Control Toolbox ?

 

[Brian from Maui]

Hi Brian
Can your friend not use the std scroll bar within Excel @ Bottom ?
What type of scrollbar, ToolBox or Control Toolbox ?

From the Control Tool Bar and this is the code he has

Private Sub ScrollBar1_Change()

End Sub

I told him to use freeze pane and then scroll, but.....

 

[Ivan F Moala]

Hi Brian
Can your friend not use the std scroll bar within Excel @ Bottom ?
What type of scrollbar, ToolBox or Control Toolbox ?

From the Control Tool Bar and this is the code he has

Private Sub ScrollBar1_Change()

End Sub

I told him to use freeze pane and then scroll, but.....

Yes, that would be a better option other wise with that control it would scroll off the visible view