Scroll Bar- Move one cell to right

T

Thomp

Is there a way to use a control bar that will move the focus to right
one cell. Looking for the same kind of functionality as a freeze pane
but with a control box scroll bar on the worksheet
 
A

AB

I'm not sure i understood completely but try putting the scrollbar
control (ScrollBar1) onto your ws and then play around with this code
and see what happens.

Private Sub ScrollBar1_Change()
Static ScrollValue As Long
Dim COLs_To_Move As Long

COLs_To_Move = Me.ScrollBar1.Value - ScrollValue
ActiveWindow.SmallScroll toright:=COLs_To_Move
ScrollValue = Me.ScrollBar1.Value
ActiveCell.Offset(0, COLs_To_Move).Select


End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frame control scroll bar 0
Scroll bar (control) doesn't scroll!! ??? 3
Scroll Bar in Text Box will not work 2
using a scroll bar to make a slide show 1
Why doesn't the Control tab appear in the Format Control window? 1
Scroll Bar Control 1
list box / scroll bar 2
Vertical Scroll bar w/ picture background 4

Top