+ Reply to Thread
Results 1 to 10 of 10

scroll text

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    scroll text

    hi all does anybody have any code or can help, to enable text in a text box to scroll automatically either via a macro or vba

    many thanks

    scouse13

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: scroll text

    Hi, a macro is VBA and VBA is the macro language.
    Could you explain yourself a little more and the title 'scroll text' is very vague
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: scroll text

    hi keebellah
    what I want to achieve is have a text box and for the text inside to scroll up, as soon as the document is opened the text starts scrolling, that's what I meant by vba, rather than put the vba in a macro and a button has to be called to call the macro, hope this explains a bit better what I want to do

    scouse13

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: scroll text

    No not really, vba does not imply a button, you can activate it i many ways, but the scrolling and textbox,
    Attach a sample file with the said textbox and the text and then what do you mean by scrolling, up, down, left, right or like one of those ticker tapes?
    Like I said it's still vague.
    Don't expect someone else to try to think what you are thinking and think something up that he thinks might be what you are thinking.
    Assumptions are killing

  5. #5
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: scroll text

    thanks keebellah
    you just messed up my thinking lol,
    I will send a file tomorrow and hopefully it will explain it more, I do appreciate your posts back and understand the frustrations, when things are not explained correctly.

    scouse13

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: scroll text

    Have you tried scrolling text in a textbox manually? If not I suggest you try that; maybe then you'll see what the difficulty is.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: scroll text

    @macropod: that's just it, you cannot ASSUME it's a vertical scroll and yes, it is difficult, but, let the OP explain it, then the brain work can begin,

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: scroll text

    My post made no assumption about the scroll direction (the only one to ASSUME so seems to be you) and, as for 'difficult', just try doing it any direction manually in a Word text box (this is the Word forum, after all)...

  9. #9
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: scroll text

    I stand corrected for my assumption, I rest my case
    I had checked the 0 replies and AASUMEd it was Excel, that's for not checking where it was posted and the "extended" and "descriptive" post title.
    I'll forget about this one

  10. #10
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: scroll text

    Been there, done that!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. floating text box when scroll
    By NYBoy in forum Excel General
    Replies: 4
    Last Post: 05-18-2020, 09:30 AM
  2. Text Box with scroll bar
    By mrvette134 in forum Excel General
    Replies: 8
    Last Post: 01-19-2015, 06:50 PM
  3. Add scroll baqr to a cell with lot of text in it.
    By Neetu Aggarwal in forum Excel General
    Replies: 1
    Last Post: 03-20-2014, 06:44 AM
  4. [SOLVED] Scroll down to keep up with text
    By KateMaz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 05:20 AM
  5. How do you get text to follow scroll???
    By msm5167 in forum Excel General
    Replies: 1
    Last Post: 05-22-2009, 09:41 AM
  6. scroll text
    By Sonyk in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 04-12-2009, 08:28 PM
  7. userform text box and a scroll bar
    By Shawn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2006, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1