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

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

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

Send Multiple Emails From Excel | Send Bulk Mail from Excel Sheet with Attachment in One Click

Send Multiple Emails From Excel | Send Bulk Mail from Excel Sheet with Attachment in One Click Download VBA Code Notepad file - Click here D...

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