Results 1 to 3 of 3

Flashing Label using a Timer within a UserForm

This is a discussion on Flashing Label using a Timer within a UserForm within the Excel Questions forums, part of the Question Forums category; Hi, I would like to be able to have Label, within an Excel UserForm, flash/blink every second or so and ...

  1. #1
    Board Regular
    Join Date
    May 2006
    Location
    Vancouver, BC, Canada
    Posts
    93

    Default Flashing Label using a Timer within a UserForm

    Hi, I would like to be able to have Label, within an Excel UserForm, flash/blink every second or so and change to a different color. However, I do not want it to use a function that waits a specific amount of time since I would like to be doing other tasks concurrently thus leading me to believe a Timer, that trigers an event every second or so, is the best option.
    I searched google and people were talking about the Form_Timer() and Form_Current() Subs, but as far as I can tell these Subs are not availiable for UserForms when using VBA for Excel (possibly they are availiable in VB6?). Does anyone know of a Timer function that I could use to make text blink and possibly also make Scrolling Text by changing the Labels position each timer event?

    Thanks,
    -Taylour

  2. #2
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,748

    Default

    Check out the XL application's OnTime method.

  3. #3
    Board Regular DominicB's Avatar
    Join Date
    Oct 2005
    Location
    England
    Posts
    1,569

    Default

    Good morning taylourmackay

    You can see an example of the OnTime command here :

    http://www.cpearson.com/excel/BlinkingText.htm

    The example is not specific to a UserForm label, but shouldn't be difficult to adapt.

    HTH

    DominicB
    Now available : Ultimate Add-In 2007
    Integrates directly into the Office Excel Ribbon

    The Ultimate Utilities Excel Add-In (v1.52) is now available to download.
    http://www.dom-and-lis.co.uk/
    200+ New Excel tools. 30+ New Excel functions. Free!
    New! Show Autofilter Criteria

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com