Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2020, 12:18 AM
LilyBo LilyBo is offline Checkbox Windows 10 Checkbox Office 2019
Novice
Checkbox
 
Join Date: Mar 2020
Posts: 3
LilyBo is on a distinguished road
Default Checkbox


Hi all! Is it possible to use track changes to show the initials of the person who just ticked a checkbox?
Reply With Quote
  #2  
Old 03-20-2020, 12:36 AM
macropod's Avatar
macropod macropod is offline Checkbox Windows 7 64bit Checkbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Assuming you're using a content control checkbox, yes - Track Changes records who last updated it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-20-2020, 12:41 AM
LilyBo LilyBo is offline Checkbox Windows 10 Checkbox Office 2019
Novice
Checkbox
 
Join Date: Mar 2020
Posts: 3
LilyBo is on a distinguished road
Default

Ok thanks! Do you know if it's possible to get the initials of the person in the checkbox instead of the tick?
Reply With Quote
  #4  
Old 03-20-2020, 12:48 AM
macropod's Avatar
macropod macropod is offline Checkbox Windows 7 64bit Checkbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What you get really for tracked change depends on what's in the username field under File|Options|General.

Checkboxes display check characters, not text. A macro could be used to insert the initials after the checkbox (e.g. in a text content control). Besides which, simply recording the initials isn't especially helpful if someone unchecks a checkbox someone else had checked - without the checkbox being present, you'd never know what the final check state was.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-20-2020, 05:37 PM
Guessed's Avatar
Guessed Guessed is offline Checkbox Windows 10 Checkbox Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You could use an on exit macro on Content Controls to record the user who last visited the checkbox. For instance the macro could write the username to the Tag property or somewhere else in the document.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 03-22-2020, 05:07 PM
LilyBo LilyBo is offline Checkbox Windows 10 Checkbox Office 2019
Novice
Checkbox
 
Join Date: Mar 2020
Posts: 3
LilyBo is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
You could use an on exit macro on Content Controls to record the user who last visited the checkbox. For instance the macro could write the username to the Tag property or somewhere else in the document.
Thanks! I'll definitely look into that
Reply With Quote
  #7  
Old 03-22-2020, 05:43 PM
macropod's Avatar
macropod macropod is offline Checkbox Windows 7 64bit Checkbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you use a checkbox content control titled 'Chk1', for example, and a corresponding text content control titled 'Chk1Inits', you could use a ContentControlOnExit macro like:
Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)
Application.ScreenUpdating = False
With CCtrl
  If .Type = wdContentControlCheckBox Then
    With ActiveDocument.SelectContentControlsByTitle(.Title & "Inits")(1)
      .LockContents = False
      .Range.Text = Application.UserInitials
      .LockContents = True
    End With
  End If
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
check box, initials

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox One Content Control Checkbox checks another Content Control Checkbox DEsh Word VBA 2 10-06-2017 08:23 PM
Checkbox Checkbox in Userform lukael Excel Programming 5 02-18-2014 05:20 AM
checkbox issue Deepa Shrestha Word 3 07-24-2013 12:05 PM
macro on checkbox macrohelp Word VBA 0 03-06-2009 03:33 PM
resizing a checkbox?? aceensor Excel 0 05-10-2006 01:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft