Scroll worksheet

[Keith.Jackson]

I would like to have my active sheet scrollbar right to a certain place when I change the value in a userform textbox.
I'm trying to make a certain place on the sheet visible from underneath the user form. Is this possible?

Thanks

 

[agihcam]

try selecting the range;

range("ba20").select

 

[Keith.Jackson]

That doesn't scroll the page. It selects the cell whereever it may be but does not make that cell visible even if it is off the page.

 

[agihcam]

seems like you have set the screenupdating to false

try;
application.screenupdating=true
range("ba20").select
application.screenupdating=false

 

[SydneyGeek]

Something like this...

Sub ScrollLeft()
    Range("AZ45").Select
    ActiveWindow.ScrollRow = Selection.Row
    ActiveWindow.ScrollColumn = Selection.Column
End Sub

Denis