Create form with checkbox les that expand and collapse sections of the form?

Aug 5, 2019
Reaction score

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question