How to create userform in excel in hindi Part - 2 Excel VBA - Create Use...
How to create Userform in excel in hindi Part-2
VBA Code File Download - Click here
Excel VBA Code Copy From
Private Sub Cmd2_click()
'Clear the input box
TextBox1.value=""
TextBox2.value=""
End Sub
Private Sub Cmd3_click()
'Hide the form
Userform1.hide
End Sub
Private Sub Cmd1_click()
'transfer user input to colm
Dim rng1, rng2 As range
'who is rng1, rng2
Set rng1=Cells(Rows.count, 1).End(xlup).offset(1,0)
Set rng2=rng1.offset(0,1)
rng1.value=TextBox1.value
rng2.value=TextBox2.value
'Clear the input box
TextBox1.value=""
TextBox2.value=""
TextBox1.Setfocus
End Sub
How to create userform in excel Part - 1
Post a Comment