+ Reply to Thread
Results 1 to 7 of 7

Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

  1. #1
    Registered User
    Join Date
    03-08-2011
    Location
    Dover NH
    MS-Off Ver
    Excel 2007
    Posts
    22

    Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

    I am trying to create a tracking sheet that will be used by several departments to track production of large documents. Since the activities may not happen in a strict order, the tasks are listed in a drop down list. When the user selects the activity in column A from a drop down list, I would like their user name to appear in column C and the date and time to appear in column D. I have attached a sample worksheet.

    Thank you for any help possible.
    -Evelyn
    Attached Files Attached Files
    Last edited by EHarvill; 07-11-2011 at 03:23 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: User Name and Date/Time Stamp in Tracking Sheet

    Hi Evelyn

    Sorry, misread so reply withdrawn
    Last edited by Roger Govier; 07-11-2011 at 01:15 PM.
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

  3. #3
    Registered User
    Join Date
    03-08-2011
    Location
    Dover NH
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: User Name and Date/Time Stamp in Tracking Sheet

    Hi Roger,
    Thanks for your reply, that was not exactly what I needed. Sorry for not being more specific. All these folks are not used to having to fill in these kinds of logs so I want to automate as much for them as I can. I thought maybe I could use VBA code that would automatically fill in their user name and the date and time when they picked the task they are working on.

    I edited my title to try to make it clearer.
    -Evelyn

  4. #4
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

    Hi Evelyn
    I'm sorry I misread your firstrequirement, and tried to withdraw my posting.

    Try this one with the following code and see if that does what you want.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-08-2011
    Location
    Dover NH
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

    Hi Roger, thanks!
    It sort of does it. On that one, the name pops up when I click in column C. To cut down on steps for the users who are being dragged reluctantly into the use of an electronic tracking sheet instead of a paper one (and to eliminate the chance for them to neglect to put in their names), I would like the info to show up when they select a task in Column A. Is that possible?
    Thanks for being so patient with me!
    -Evelyn

  6. #6
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

    Hi Evelyn

    Sorry for the slow response, my Internet connection is playing up.

    No problem, just delete the code I gave you on sheet Production, and replace with the following.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-08-2011
    Location
    Dover NH
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Macro needed to add User Name and Date/Time Stamp in Tracking Sheet

    Thanks Roger, that worked great!

+ 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