+ Reply to Thread
Results 1 to 2 of 2

How to start a Macro/Timer, then stop the timer after Pressing enter key on a Cell?

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to start a Macro/Timer, then stop the timer after Pressing enter key on a Cell?

    Good afternoon all!

    I working on a time testing sheet for my group. I was able to figure out how to integrate a stopwatch, but cannot figure out how to combine it with my (One) Macro.

    What I would like it to do is:

    Once I hit my START level 1 button, I would like it to start the Timer, execute the (One) Macro to set up the Queue, then stop the Timer after hitting Enter on Cell (E26)

    I figured out how to make my stopwatch run continuously when switching sheets, but it stops when I make changes in Sheet 1.

    I may be going at this the wrong way so any help is greatly appreciated. Iíll attach my worksheet so you can see what I have so far.

    Thanks
    Attached Files Attached Files
    Last edited by wrcknz; 11-29-2012 at 04:05 PM.

  2. #2
    Registered User
    Join Date
    11-16-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to start a Macro/Timer, then stop the timer after Pressing enter key on a Cell?

    Okay,

    I figured out the Application.Run"MACRO" command.

    Has anybody figured out how to stop my timer after Pressing Enter on Cell (E26)

    I came up with:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    But can't finish it.

+ Reply to Thread

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