Quote:
Originally Posted by Guessed
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.
|
thank you so much. That's very helpful indeed!
I've added it to the code for the command button however it doesn't seem to have worked. The bookmarks are still there. I have attached the form for you to see.