View Single Post
 
Old 02-14-2022, 10:28 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I am curious why you need two userforms for this when you appear to have both documents open. Wouldn't it make sense to provide the data to both documents from the same userform? In fact your code already appears to do that.

You could also read and write data via the registry using SaveSetting and GetSetting e.g.
Code:
Public Function appID() As String
     appID = "MyApp"
lbl_Exit:
    Exit Function
End Function
Code:
'Write
SaveSetting appID, "Config", "My Initials", txtInitials.Text
'Read
txtInitials.Text = GetSetting(appID, "Config", "My Initials", "Mr Dr")
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote