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

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

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

How To Convert Data in Columns into Rows in Excel Document

How To Convert Data in Columns into Rows in Excel Document Download Notepad file - Clickhere Copy code here: Function SplitCellToRows(CellVa...

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