![]() |
#2
|
||||
|
||||
![]()
Change the userform code to
Code:
Option Explicit Private Sub CommandButton1_Click() Dim tmp As String If TextBox1.Text <> "" And TextBox1.Text <> TextBox1Before.Text Then WriteBk2 "TextBox1", TextBox1.Text TextBox1Before.Text = TextBox1.Text End If If TextBox2.Text <> "" And TextBox2.Text <> TextBox2Before.Text Then WriteBk2 "TextBox2", TextBox2.Text TextBox2Before.Text = TextBox2.Text End If If TextBox3.Text <> "" And TextBox3.Text <> TextBox3Before.Text Then WriteBk2 "TextBox3", TextBox3.Text TextBox3Before.Text = TextBox3.Text End If Unload Me End Sub Private Sub UserForm_Initialize() Dim tmp As String tmp = ReadBk("TextBox1") TextBox1.Text = tmp TextBox1Before.Text = tmp tmp = ReadBk("TextBox2") TextBox2.Text = tmp TextBox2Before.Text = tmp tmp = ReadBk("TextBox3") TextBox3.Text = tmp TextBox3Before.Text = tmp End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dyb | Word VBA | 5 | 02-18-2022 07:22 AM |
![]() |
enso | Word | 2 | 05-20-2019 02:58 AM |
![]() |
Rod_Bowyer | Excel Programming | 7 | 10-14-2018 11:49 PM |
Userform without inserting Bookmark text | mktate | Word VBA | 8 | 12-31-2015 01:11 PM |
Send Userform Text to Bookmark | tddfs | Word VBA | 5 | 07-30-2015 05:55 PM |