Thank you again .I have no idea on vba,just trying to learn simple userform text box calculations .I was trying to do that way input in four text boxes and out put in cell C1,C2,C3,C4 after multiplying textbox1,2,3,4,with cell B1,B2,B3,B4.
Sheets("data").Range("C1") =TextBox1*Sheets("data").Range("B1")
Sheets("data").Range("C2") =TextBox2*Sheets("data").Range("B2")
Sheets("data").Range("C3") =TextBox3*Sheets("data").Range("B3")
Sheets("data").Range("C4") =TextBox4*Sheets("data").Range("B4")
Private Sub Textbox1_change()
If IsNumeric(textbox1) Then
Sheets("data").Range("C1") =TextBox1*Sheets("data").Range("B1")
End if
End Sub
Private Sub Textbox2_change()
If IsNumeric(textbox2) Then
Sheets("data").Range("C2") =TextBox2*Sheets("data").Range("B2")
End if
End Sub
Private Sub Textbox3_change()
If IsNumeric(textbox3) Then
Sheets("data").Range("C3") =TextBox3*Sheets("data").Range("B3")
End if
End Sub
Private Sub Textbox4_change()
If IsNumeric(textbox4) Then
Sheets("data").Range("C4") =TextBox4*Sheets("data").Range("B3")
End if
End Sub