+ Reply to Thread
Results 1 to 8 of 8

Datestamp with Initials

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    earth, milky way
    MS-Off Ver
    Excel 2010
    Posts
    47

    Datestamp with Initials

    Is it possible to input a macro which will stamp the date along with the initials of the user that excel is registered to?

    The project I am working on will require two different users to check off a specific task, and I'd like the checkbox to show the date of the check and the computer user who initiated the check.

    Thank you in advance
    Last edited by burlywood66; 05-13-2010 at 08:51 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Datestamp with Initials

    Application.UserName returns the name of the user; I don't know how to get their initials. To stamp a cell you can do this:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Datestamp with Initials

    Do you mean something like this?

    Please Login or Register  to view this content.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Datestamp with Initials

    Try this variable somewhere in your code, maybe WorksheetChange?

    Please Login or Register  to view this content.
    This
    gets the Users' Login Name (Unique), not the Applications' UserName which will be the same in many cases

    Hope this helps.

  5. #5
    Registered User
    Join Date
    01-28-2010
    Location
    earth, milky way
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Datestamp with Initials

    Thank you all for your responses, but to help get me going, would you mind creating a checkbox object for me, that when clicked will return that info in a cell to the right (maybe attaching a spreadsheet)

    Thanks again for all your help. I really appreciate you taking the time.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Datestamp with Initials

    Quote Originally Posted by burlywood66 View Post
    ...would you mind creating a checkbox object for me, that when clicked will return that info in a cell to the right (maybe attaching a spreadsheet)
    See attached. Is the format of the stamp/name sufficient or do you need it split into multiple cells, or some other format?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-28-2010
    Location
    earth, milky way
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Datestamp with Initials

    Thank you so much! I can modify it from here.

    Final question - does the code have to specify a specific cell to send the information to, or can i instruct it to input the information one cell from the right of the checkbox.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Datestamp with Initials

    Quote Originally Posted by burlywood66 View Post
    Thank you so much! I can modify it from here.

    Final question - does the code have to specify a specific cell to send the information to, or can i instruct it to input the information one cell from the right of the checkbox.
    The checkbox is located in a geometric grid that is superimposed on the worksheet, rather than being associated with a particular cell. Its position can't be related to cells, as far as I know. I know of no way to address "the cell to the right of the checkbox."

    (A checkbox's value can be linked to a cell, but that has nothing to do with the physical position of the checkbox.)

+ 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