Hello,
I am trying to create a form that uses checkboxes to expand and collapse sections of the form. So depending on if the checkbox is checked or not, certain parts of the form will be visible.
I have look up several methods and have found that creating bookmarks and using an Active X Control checkbox with some VBA code to link the checkbox to the bookmark so that when the checkbox is clicked, it hides or displays the bookmarked section. However for some reason this method seems to be sensitive to issues. It will be fine when testing and then the checkbox will abruptly stop affecting the bookmarked text anymore. The VBA code I’m using behind the checkbox simply sets the relevant bookmarked section as ‘hidden’ so it’s not particularly complicated.
Any and all suggestions and advice are welcome. Thank you.
I am trying to create a form that uses checkboxes to expand and collapse sections of the form. So depending on if the checkbox is checked or not, certain parts of the form will be visible.
I have look up several methods and have found that creating bookmarks and using an Active X Control checkbox with some VBA code to link the checkbox to the bookmark so that when the checkbox is clicked, it hides or displays the bookmarked section. However for some reason this method seems to be sensitive to issues. It will be fine when testing and then the checkbox will abruptly stop affecting the bookmarked text anymore. The VBA code I’m using behind the checkbox simply sets the relevant bookmarked section as ‘hidden’ so it’s not particularly complicated.
Any and all suggestions and advice are welcome. Thank you.