When a checkbox is checked, can the TRUE somehow bring up the current user's name and enter it in a cell so there is a history of who checked the checkbox i.e. the 'last modified by' name you can see in the file info? Am I making any sense?
When a checkbox is checked, can the TRUE somehow bring up the current user's name and enter it in a cell so there is a history of who checked the checkbox i.e. the 'last modified by' name you can see in the file info? Am I making any sense?
May be
![]()
Please Login or Register to view this content.
You can use the BuiltinDocumentProperties for that purpose.
But do you want to keep a log of all people who made changes or just see the name of the last person in the same cell over and over again?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Abdul - that worked perfectly. Rep added!
Bakerman, I will be using multiple checkboxes and I have applied Abdul's solution and so far, all good!
Thanks for your assistance, guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks