View Single Post
 
Old 06-29-2016, 05:06 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote