Dear all, I am new to Excel VBA, esp for treating it database. Could hemal explain how to use it?
Also, I cannot open the file from Noorain, my excel version is 2003. Thanks a lot! Darwin 2011/9/23 NOORAIN ANSARI <noorain.ans...@gmail.com> > Dear Hemal, > > Please try below code, sheet is attached for ur help. > > Private Sub CommandButton2_Click() > Dim i As Long > Application.ScreenUpdating = False > Application.EnableEvents = False > i = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1 > With frmSalary > Sheet1.Cells(i, 1).Value = .txtEmpcode.Value > Sheet1.Cells(i, 2).Value = .txtFname.Value > Sheet1.Cells(i, 3).Value = .txtMname.Value > Sheet1.Cells(i, 4).Value = .txtLname.Value > Sheet1.Cells(i, 5).Value = .txtFullname.Value > Sheet1.Cells(i, 6).Value = .txtB.Value > Sheet1.Cells(i, 7).Value = .txtDA.Value > Sheet1.Cells(i, 8).Value = .txtHRA.Value > Sheet1.Cells(i, 9).Value = .txtDed.Value > Sheet1.Cells(i, 10).Value = .txtNet.Value > Sheet1.Cells(i, 11).Value = .txtAnn > End With > Application.ScreenUpdating = True > Application.EnableEvents = True > > End Sub > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > > > On Fri, Sep 23, 2011 at 1:23 PM, hemal shah <hemali...@gmail.com> wrote: > >> Hello Friends, >> >> I have made user form for salary in excel vba editor. >> >> I want to generate database by using that user form. >> >> Kindly help me for this. >> >> See the attachment >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
