Thanks so much.. On Sep 23, 10:27 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > Dear Darwin, > > Please find attached sheet in Excel 2003 verson. > Hope it will be help to u. > > 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 9:38 PM, Darwin Chan > <darwin.chankaw...@gmail.com>wrote: > > > > > > > > > > > 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 athttp://www.excel-macros.blogspot.com > >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > > Salary(solved).xls > 281KViewDownload
-- ---------------------------------------------------------------------------------- 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
