CODEWITHSUNDEEP
excelvba
vijay
vijay

Reputation: 19

how to scroll the scrollbar automatically in excel

I have linked the data with the scrollbar in excel and want to scroll the scrollbar automatically instead of by mouse. Please let me know if this can be done.

Upvotes: 1

Views: 386

Answers (1)

Greg Viers
Greg Viers

Reputation: 3523

This VBA scrolls down one row at a time:

ActiveWindow.ScrollRow = ActiveWindow.ScrollRow + 1

Upvotes: 2

Related Questions