Displayed result in Form2 from CommandButton in Form1.

[MissAugust]

Dear Experts,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a worksheet which do data analyse. I am using two form here, where Form1 used to input data from textbox into excel, which successfully done.

What I want to do is to use CommandButton from Form1 (CMDSHOW) and the result in excel will show up in textbox in Form2. I have the result in P10 to show in textbox1, result in S10, S11, S12 to show in textbox2, textbox3, textbox4. Can someone please advise me? Thank you in advance.

 

[vaskov17]

code for the command button on Form1:

Private Sub CommandButton1_Click()
    Dim ws As Worksheet
    
    Set ws = Worksheets("Sheet1")
    
    Load Form2
    
    With Form2
        .TextBox1.Text = ws.Range("P10").Text
        .TextBox2.Text = ws.Range("S10").Text
        .TextBox3.Text = ws.Range("S11").Text
        .TextBox4.Text = ws.Range("S12").Text
    End With
    
    Form2.Show
End Sub

 

[MissAugust]

Thanks a lot vaskov17, it run perfectly.. ^_^