Userform "Quote of the Day"

[Shea2288]

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

[TMS]

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