View Single Post
 
Old 06-29-2016, 10:03 AM
mrsjetset mrsjetset is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2016
Posts: 5
mrsjetset is on a distinguished road
Default

Alright, got that situation all worked out. I think I was using an incorrect copy of the document where the bookmark had been replaced and not re-added (operator error) because I re-added the subroutine and set it up for all the bookmarks, and everything is hunky-dory with that part now.

The bigger issue that I have left is that the userform doesn't Unload on cmdClick_OK, even though I have Unload Me as the last line before the end of the subroutine. I click the X and it goes away, but I'd like for the OK click to populate the document and close the form. I think it's possible, but I'm not 100% sure. If I have to add in a Close button it's not the end of the world, but from everything I've read it seems Unload Me should work. Can't seem to find a good reference for Word VBA that's current.

Next issue is the cross-references keep the format of the original bookmark. I thought I read somewhere that there was a way to tell them to keep their own formatting and use just the value of the bookmark, but I have searched again and cannot seem to find what the solution to that was, nor have I been able to recall it.

A third, much more minor issue, is that my userform is "multipage" and I can't figure out how to set it up so it always shows the first page first. Seems that whichever page I'm on when I save it is the one the userform opens on. This is, however, a very minor issue, and I don't anticipate a lot of changes once the form is in use so it's not a big deal, I just wondered if there was a property I needed to change the value of.

If I need to post the code or the file I'm happy to do so, as long as the forum will agree with me today.
Reply With Quote