I have several bookmarks and cross-references to fill in from a userform, and finally have gotten the basic code to work (first solution found here: http://www.word.mvps.org/FAQs/Macros...AtBookmark.htm). However, I have not a huge number, but enough I'd like to be able to get the subroutine to work. I have put it in several places in the userform code, but I keep getting a 5441 error: The requested member of the collection does not exist. As a side note, the very first time I inserted it (absolutely last thing in the code) it did work (I called it only once in the cmdOK_Click subroutine). When I called it more times for more bookmarks, I got this error. Assistance is greatly appreciated!

That code is most likely not your problem. You will need to post your template so the whole code can be examined. Anything that deletes, cuts or replaces a range could be responsible for removing your bookmarks.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

I think the code has to be the issue seeing as how I didn't edit the document or the form, only the code. And since the original solution works when used over and over but the subroutine produces an error code, I don't see how it can not be the code. I will just continue to use the original solution en masse I suppose.

You haven't specified where the code is failing. However if the function is throwing an error like that then there are only two possibilities:
1. There is no activedocument.
2. You are passing a bookmark name that doesn't exist in the activedocument.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

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.

If the userform is remembering the multipage you were on then it is because it remained loaded in memory. I usually place the "Unload userformname" line in the same Sub that displays the userform - not in the userform module itself. You can use a Me.Hide command to allow that sub to proceed. If the form is unloaded then it will default to the initial multi-page next time the userform is summoned.

I have no idea if the "forum will agree with you today" but if you don't post your code we can't tell you why it doesn't work. The only code you have shown us so far isn't dealing with cross-references but it is replacing a bookmarked range with a string and then wrapping that in a bookmark - this will ALWAYS result in formatting that looks the same as the previous text since no formatting is contained in a string.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia