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
Thanks![]()
Please Login or Register to view this content.
Liju
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
Thanks![]()
Please Login or Register to view this content.
Liju
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
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):
No need for an extra Function.![]()
Please Login or Register to view this content.
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
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
![]()
Please Login or Register to view this content.
Hi, Liju ,
maybe use
Even users who do not know very much about Office may change the Application.Username at their will...![]()
Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks