Forum Discussion

Copper Contributor

Aug 12, 2024

Solved

Auto-scroll an Excel workbook

Hi Guys, Looking for some assistance, I am hooking up a mini PC to a Samsung Smart TV to display an Excel spreadsheet, bascially highlights what projects we have on and some info in a table. ...

excel

Macros and VBA

JKPieterse
Aug 13, 2024
DylanBrown It should continue to run just fine, the code looks at the current size of the table each time it runs.

GeorgieAnne

Iron Contributor

Aug 12, 2024

Hello @DylanBrown
You definitely should start working in VBA. If you want to have all the fun that is.
On the Web there are plenty of examples of what you want to do, here are some examples:
https://forum.ozgrid.com/forum/index.php?thread/86754-scroll-screen-to-active-cell-row/
https://www.automateexcel.com/vba/scroll/
https://stackoverflow.com/questions/12636434/how-do-i-make-an-excel-worksheet-scroll-to-a-row-programatically

You could also write some code to remove the row of a completed task from the display.

Let me know if you need more help understanding the code or adjusting it to your needs.
TAKE THE PLUNG you will not regret it at all 😉

GiGi

DylanBrown

Copper Contributor

Aug 12, 2024

I have done a little VBA a while ago but not for anything like this. Would I need some sort of trigger to start the scrolling? I'm planning on having this always on on the TV so it doesn't turn off but just in case it does I don't want it to be a nightmare to start the code again.

I'm just reading through this one that you shared now - https://www.automateexcel.com/vba/scroll/

Little confused where to start.