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

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

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

"Master REGEX in Excel | Boost Your Productivity with These Powerful Tips!"

 "Master REGEX in Excel | Boost Your Productivity with These Powerful Tips!" Regex (Regular expressions), is a tool that finds pat...

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