Macro (button) that brings you back to the top

**SHELTONUNDERDOG** · 03-30-2015, 03:21 PM

Hello, I have a three macros assigned to three form control buttons. You click on the first it takes you to Cell B9, you click on the second it will take you to Cell B321, and the third will take you to Cell B488.

My problem is if I am down at row 321 and want to quickly go back to the top row I click on the first button, works fine unless I have that row hidden then the curser is in the hidden row (cell B9) but the sheet does not auto scroll up. How can I make it scroll back up and still have the option of hiding the row?

(Rows 1-8 are set for Freeze Pane, row 9 is the first possible line of data that could be entered)

**buran** · 03-30-2015, 03:42 PM

ActiveWindow.ScrollRow=9

**SHELTONUNDERDOG** · 03-30-2015, 03:57 PM

how would I plant that in my macro:

Sub Button ()
Range("B9").Select
End Sub

**buran** · 03-30-2015, 03:59 PM

Sub Button ()
ActiveWindow.ScrollRow=9
Range("B9").Select
End Sub

**kosherboy** · 03-30-2015, 04:00 PM

Hi.
Try this:

Private Sub CommandButton1_Click()
Dim i As Long
Dim j As Long

Application.GoTo Cells(Rows.Count, "B").End(xlUp), Scroll:=True
With ActiveWindow
i = .VisibleRange.Rows.Count / 2
j = .VisibleRange.Columns.Count / 2
.SmallScroll Up:=i, ToLeft:=j
End With
End Sub

**SHELTONUNDERDOG** · 03-30-2015, 04:04 PM

Thank you Buran, that works perfectly!

Macro (button) that brings you back to the top

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro (button) that brings you back to the top

Re: Macro (button) that brings you back to the top

Re: Macro (button) that brings you back to the top

Re: Macro (button) that brings you back to the top

Re: Macro (button) that brings you back to the top

Re: Macro (button) that brings you back to the top

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Command button brings up picture viewer instead of running macro.

A formula that can be used in whole column that brings back a positive result.

COUNTIF brings back too many numbers

Insert a button that brings up a form?

[SOLVED] my sumif statement brings back mutiple answers, how do I fix it?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions