+ Reply to Thread
Results 1 to 6 of 6

Last editted User Name

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Last editted User Name

    Hi,

    I Require in B1 cell from which user name(Windows Name) editted A1 cell as the same as B column is it Posible?

    am using the mentioned Program for getting username
    Please Login or Register  to view this content.
    Thanks

    Liju

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Last editted User Name

    Copy the below code and do right click on sheet tab and select view code and paste the below code. Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

    C1 cell is assigned to enter the username when the entry occurs in A1 or b1 cell.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Last editted User Name

    Hi, Liju144,

    maybe just like this - you would need to tell us what should happen if there is already an entry in Column B, right now it will be substituted (IŽd recommend to combine the name with the time-stamp Now):
    Please Login or Register  to view this content.
    No need for an extra Function.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Last editted User Name

    Thanks,


    Actually i required if any cell in A column the user was eddited for same row next column i require the User Name.

    Thanks

    Liju

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Last editted User Name

    Please Login or Register  to view this content.

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Last editted User Name

    Hi, Liju ,

    maybe use
    Please Login or Register  to view this content.
    Even users who do not know very much about Office may change the Application.Username at their will...

    Ciao,
    Holger

+ 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. [SOLVED] Grouped Data Blocks editted to Columns of Data based off left cell value?
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-10-2013, 03:06 PM
  2. Insert user's name into cell based on windows user login when a button is clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-16-2011, 01:08 PM
  3. Match new password to specific user and update list via custom user form
    By Sargekd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2011, 09:40 AM
  4. Pause macro for user input then search for user's answer across multiple sheets
    By sassy2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2009, 03:55 AM
  5. How do I hide macros in Excel so they can't be editted?
    By Donald McAllister in forum Excel General
    Replies: 1
    Last Post: 08-02-2006, 05:10 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