View Single Post
 
Old 01-14-2020, 12:42 AM
RevoMedia RevoMedia is offline Windows 10 Office 2016
Banned
 
Join Date: Jan 2020
Location: Doetinchem, NL
Posts: 3
RevoMedia is on a distinguished road
Default Let bookmark check if there are empty bookmarks before and place sentence there?

For a person im helping with his VBA, I have the following question:

I have 9 bookmarks down to each other.
I have 9 optionboxes in a UserForm. They all represent a sentence.
I select option 1 and 4, so sentence one and 4 are loaded into the document by the bookmarks.

But, there are empty spaces because optionbox 3, 4, 5, 6, 7, 8 and 9 are not checked.
Is it possible to let VBA look if there are optionboxes not checked, to load sentence 1 and 4 in bookmark 1 and 2, for example: when 9 is also checked it must be loaded to BookMark 3.

It is now:
| Sentence 1
|
|
| Sentence 4
|
|
|
|
| Sentence 9

but is need to be:
|Sentence 1
|Sentence 4
|Sentence 9
|

Hope you guys understand me because my english is a little bad.

Thanks in advance!
Reply With Quote