View Single Post
 
Old 10-21-2018, 06:45 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,164
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

Kate
You said you have a userform with checkboxes. In that userform, you can select a checkbox and see its properties in the Properties Window. There is a property called Tag. Set the value of this property to match the name of the bookmark which should show when that checkbox is ticked.

The code I supplied should sit in the subroutine that runs when the user clicks a button to dismiss that userform (ie after they tick the checkboxes they want). The code loops through all the objects on the userform and if it finds a checkbox with a tag property that matches a bookmark that exists in the document, it either hides or shows that text based on the value of the checkbox.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote