Execl VBA:How to retain with the values in Textboxes in userform while switching btw pages

EXCEL VER. 2003

I am populating my userform fields from a word documents. I have three pages in my userform. When I change something in the field that is being populated from the word and after that i move to next page. And when i return back to previous page all the changes are gone.


Could you please help to retain these values.

Thanks for you Kind Reply.

I have only written this.

Private Sub NextPage1_Click()
page1.Hide
page2.Show
End Sub

Please tell me if anything else I should code here so as to keep my values unchaged while swaping.

Note: One thing more, the values that i am not populating from word document are not changing, only the values that I am populating from word remains fixed after if I make changes also.

Sir ,

Actually the thing is that i am importing the word in excel by a macro and then from excel I am populating in userform and then after that I am doing all the validations and the whole process. So I found the idea of using this HIDE utility.

Please correct me if my idea is incorrect.

Hi ,

This is the code how i am fetching the data from excel.

page1.TextBox3 = Sheets("Data").Range("AL2")


This is the code I am using to go to next form. This field is automatically populated from Excel Sheet and then I want to change something in Textbox3. Whenevr i change and proceed to the next page and as soon as i come back that change disappears.

Private Sub NextPage1_Click()
If Me.TextBox3.Value = "" Then
page1.TextBox3.BackColor = RGB(255, 102, 102)
Me.TextBox3.SetFocus
MsgBox "This field can't be left blank", vbOKOnly, "Required Field"
Exit Sub
Else: page1.TextBox3.BackColor = RGB(255, 255, 255)
End If

If Not IsNumeric(page1.TextBox3) And page1.TextBox3 <> vbNullString Then

page1.TextBox3.BackColor = RGB(255, 102, 102)
MsgBox "Sorry, only numbers allowed"
'page1.TextBox3 = vbNullString

Exit Sub
End If

page1.Hide
page2.Show

End Sub