+ Reply to Thread
Results 1 to 1 of 1

Reset Counter

  1. #1
    Registered User
    Join Date
    07-21-2010
    Location
    Constanta, Romania
    MS-Off Ver
    Excel 365
    Posts
    10

    Reset Counter

    How can I reset this Counter ? I would like to activate a command line when I want.

    'Get setting from registry
    Counter = GetSetting("XYZ Corp", "Budget", "Count", 0)
    LastOpen = GetSetting("XYZ Corp", "Budget", "Opened", "")
    'Display the information
    msg = "Aplicatia este folosita de " & Counter & " ori."
    msg = msg & vbCrLf & "Last opened: " & LastOpen
    MsgBox msg, vbInformation, ThisWorkbook.Name
    'Update information and store it
    Counter = Counter + 1
    LastOpen = Date & " " & Time
    SaveSetting "XYZ Corp", "Budget", "Count", Counter
    SaveSetting "XYZ Corp", "Budget", "Opened", LastOpen

    'Reset Counter Code


    Thank.

    The simple solution is: „Counter=0”
    Last edited by Tuca; 03-28-2019 at 04:37 PM. Reason: Solved !

+ 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. Reset counter for equal to and more than 0
    By Darkestvalkryie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-13-2018, 12:39 AM
  2. For loop counter reset
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2014, 10:59 AM
  3. Reset Counter when a date is entered into various cells
    By asinara88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2013, 07:26 AM
  4. Counter reset
    By BN-CD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2007, 04:56 PM
  5. Counter Reset??
    By loh69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2006, 07:39 AM
  6. [SOLVED] Reset Counter
    By Ed in forum Excel General
    Replies: 3
    Last Post: 04-14-2006, 12:40 PM
  7. [SOLVED] How to Reset Workbook Counter?
    By Joseph Geretz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2006, 01:55 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