Results 1 to 7 of 7

Execute Cell with a Macro (timer)

Threaded View

  1. #1
    Registered User
    Join Date
    04-06-2006
    Posts
    24

    Execute Cell with a Macro (timer)

    Hi
    I am learning guitar and I felt that if I use random chord names by using a timer say 10 seconds to auto change the chord in Excel, I could increase my speed of changing chords. I have list of chords in A1:A17 and this formula =INDEX(A1:A17,RANDBETWEEN(1,COUNTA(A1:A17))) entered in C1.
    What I want is a Macro with a timer to run the above formula every 10 seconds and auto change the chord in cell C1. The macro to include Start and Stop button, if possible.
    Let me know where to insert the macro in the workbook.
    Any help would be appreciated.
    Thanks
    FLDS

    Note: I have posted this same request in Mr Excel forum, NO replies
    Last edited by flds; 05-13-2010 at 07:27 AM.

Thread Information

Users Browsing this Thread

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

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