Scrolling Text View in Excel

Design stock exchange view in excel

With this tutorial you will be able to make marquee text view in excel. With simple VBA code it is easy to make beautiful dashboards with scrolling text. You can make attracting dashboard such sales dashboard, stock exchange rates etc. with scrolling view of text at top. Follow below steps to make scrolling text view in excel.

1. Create button in excel with VBA code.

2. Copy below code inside button 

    myvalue = ActiveSheet.Range("b7")

    finalVal = WorksheetFunction.Rept(myvalue, 10)

    Range("c3") = finalVal

    Do

        For i = 1 To Len(finalVal)

            DoEvents

            For a = 1 To 900

                a = a + 1

            Next

            Range("c3") = Mid(finalVal, i)

        Next

    Loop

3. Copy data in B7 which will be scrolled.

4. Run the code by clicking button

Checkout complete tutorial on YouTube.