Using two userforms

[mnmhenry]

Good morning all,

I have two userforms - Userform1 & Userform2

I open Userform1 and enter data. I then unlaod Userform1 and open Userform2 to enter more data - then my command to send the data to the excel sheet but only the data from Userform2 carries across to the spreadsheet?

Why am I missing Userform1's data as I unload both sheets before transferring the data?

Unload UserForm1
'(text input)

Userform2.Show
'(text input)
Unload UserForm2

Range("K7").Select
Selection.FormulaR1C1 = TextBox16.Text (Userform1)

Range("P7").Select
Selection.FormulaR1C1 = TextBox5.Text (Userform2)

 

[mikerickson]

This code will work with Next and Previous buttons.

Private Sub butNext_Click()
    With MultiPage1
        .Value = .Value + 1
    End With
End Sub

Private Sub butPrevious_Click()
    With MultiPage1
        .Value = .Value - 1
    End With
End Sub

Private Sub MultiPage1_Change()
    With MultiPage1
        butPrevious.Enabled = (0 < .Value)
        butNext.Enabled = (.Value < (.Pages.Count - 1))
    End With
End Sub

With only two pages, a single button would work, and the MultiPage_Change routine isn't needed.

Private Sub CommandButton1_Click()
    With MultiPage1
        .Value = (.Value + 1) Mod .Pages.Count
    End With
End Sub