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

कोई टिप्पणी नहीं

टिप्पणी: केवल इस ब्लॉग का सदस्य टिप्पणी भेज सकता है.

MS Excel to WhatsApp Bulk Message in single Click

Excel to WhatsApp Bulk Message VBA Code File Download VBA Note Pad File - Click here Download Excel Practice File - Click here Copy Code her...

Blogger द्वारा संचालित.