Results 1 to 3 of 3

VBA to saty only in one sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    259

    VBA to saty only in one sheet.

    anyone know how to have this vba stay in one sheet? I am in need of help.

    Global clockOn As Boolean
    Sub runClock()
    Range("B2").Value = Now()
     If clockOn = True Then
        Application.OnTime Now + TimeValue("00:00:01"), "runClock"
    End If
    End Sub
    Sub startClock()
        clockOn = True
        runClock
    End Sub
    Sub stopClock()
        clockOn = False
    End Sub
    Last edited by arlu1201; 08-06-2013 at 01:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match Value in Sheet 1 with Sheet 2, copy entire row from sheet 1 to new sheet
    By lzyshaman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 07:48 AM
  2. [SOLVED] find code# from sheet 1 on sheet 2, compare value on sheet 1 with value on sheet 2
    By BlakeLee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2013, 01:52 PM
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  5. Replies: 2
    Last Post: 10-12-2010, 05:00 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