+ Reply to Thread
Results 1 to 3 of 3

Show the date and time in a specific cell of last time we run a macro

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Show the date and time in a specific cell of last time we run a macro

    hi there guys,

    i need a help here.

    hope u guys could help me in this.

    in a sheet, im running a macro every morning and evening by clicking a button.

    is it possible to have a macro that could state, when is the last time the button being click.

    mayb it can show in a specific cell in the same sheet.

    thanks guys! =)

  2. #2
    Registered User
    Join Date
    07-12-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Show the date and time in a specific cell of last time we run a macro

    hi dragon,

    at the end of your macro you can just enter something like

    Range("a1").Value = Now

    that should put the time and date into cell A1

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Show the date and time in a specific cell of last time we run a macro

    thanks. it works. very nice

+ 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