+ Reply to Thread
Results 1 to 2 of 2

Userform "Quote of the Day"

Hybrid View

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    16

    Userform "Quote of the Day"

    I have 100 quotes and facts listed in a worksheet range A1:A100.

    I have a UserForm with a Label that I would like to display a new quote/fact every 24 hours.

    Any suggestions? Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,201

    Re: Userform "Quote of the Day"

    Have a configuration sheet. Store a counter, starting at 0, and the date. Every time the date changes, increment the counter and store the date. Use the counter to index the list.

    You'll need to check when it passes 100 and reset it to 1.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 2
    Last Post: 02-11-2013, 04:58 PM
  2. Nested "If" problem for quote tool
    By mikera in forum Excel General
    Replies: 7
    Last Post: 01-29-2009, 02:34 PM
  3. Replies: 1
    Last Post: 07-13-2006, 09:36 AM
  4. SUMIF function in "Price quote with tax calculation" templae
    By Peter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-03-2005, 03:05 PM
  5. [SOLVED] How to quote cells when "IF" word is involved
    By Ming in forum Excel General
    Replies: 6
    Last Post: 08-12-2005, 07:05 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