+ Reply to Thread
Results 1 to 6 of 6

Make UserForm Caption marquee

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Make UserForm Caption marquee

    Hello everybody
    I'm trying to make the caption of the userform marquee I tried the following code that I tested for Label1 it works for Label but not for UserForm caption
    Please Login or Register  to view this content.
    Any help about that?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Make UserForm Caption marquee

    I tried something like that :
    Please Login or Register  to view this content.
    but I don't get my result > I want to make the caption of UF as marquee ..

  3. #3
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Make UserForm Caption marquee

    I don't know why you would want this feature on a UserForm. To me, it's annoying.

    But here's the only advise I can give you on this. Change this;
    Please Login or Register  to view this content.
    to this;
    Please Login or Register  to view this content.
    When I did that change to your first code, it worked for me. But the Userform was a little jumpy.
    Last edited by Jim885; 11-22-2014 at 04:44 PM.
    If I helped in any way, please click the star

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Make UserForm Caption marquee

    Great sir
    thanks for help
    Is there a way to make it more stable and more pretty?

  5. #5
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Make UserForm Caption marquee

    As far as making it pretty, you could change the font, change the color, or change the background. This is done in the Properties section.

    Making it more stable? I don't know. Try slowing down the time. But someone with higher skills might be able to advise you about that. I was only able to see the mistake I pointed out to you. Glad I was able to help as far as that was concerned.

  6. #6
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Make UserForm Caption marquee

    If my help solves your inquiry, could you please mark this as SOLVED and possibly add to my rep? Thanks.

+ 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. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  2. UserForm Caption Change
    By mrdoctor in forum Excel General
    Replies: 3
    Last Post: 01-13-2012, 03:36 AM
  3. Userform help - Caption will not change
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2011, 09:26 PM
  4. Userform Caption
    By Jason Zischke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2006, 03:55 AM
  5. How to format Userform caption?
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2005, 02:26 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