I am trying to do a before and after in a userform. On one side I want to capture the information prior to the change and I am using .gettext. and the information goes into the approriate textbox. The problem is when I hit enter the information changes and my before side now reflects the after. Is there a way that I can use the .gettext and "save" the information from being changed? Below is an example of what I'm doing currently
Code:
med9 = .GetText(19, 14, 19, 43)
UserForm1.TextBox9 = med9
med10 = .GetText(5, 12, 5, 43)
UserForm1.TextBox10 = med10
med11 = .GetText(6, 12, 6, 43)
UserForm1.TextBox11 = med11
med12 = .GetText(7, 12, 7, 43)
UserForm1.TextBox12 = med12
med13 = .GetText(8, 12, 8, 43)
UserForm1.TextBox13 = med13
med14 = .GetText(9, 12, 9, 43)
UserForm1.TextBox14 = med14
med15 = .GetText(10, 12, 10, 43)
UserForm1.TextBox15 = med15