+ Reply to Thread
Results 1 to 3 of 3

Add date and time stamp to a cell at the end of code

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Add date and time stamp to a cell at the end of code

    Hi,

    I have a userform that completes various functions and updates cells when a single button is clicked. Can I add code to the the end to enable a cell to be updated with the time and date, say cell A1 for example?

    Also is it possible to have the (Windows) username in another cell (all users will be unique) so it will save Jo Bloggs for example?

    I know this is possible as a Worksheet function:

    Please Login or Register  to view this content.

    Thanks in advance,

    JP
    Last edited by jpruffle; 05-08-2009 at 10:33 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Add date and time stamp to a cell at the end of code

    Hi,

    You can put this code at the end of yours to enter the required data.

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: Add date and time stamp to a cell at the end of code

    Thank you that worked perfectly.

+ 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