Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll Bar- Move one cell to right
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll Bar- Move one cell to right
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 On Jun 21, 7:52*pm, Thomp wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
KEYBOARD ARROWS SCROLL INSTEAD OF MOVE FROM CELL TO CELL!! | Excel Discussion (Misc queries) | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
Move/Scroll Specific Cell(Row) into the centre of the Screen ? | Excel Programming | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) | |||
Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) |