Please VIsit this Page.. http://www.cpearson.com/excel/Events.aspx
On Sat, Oct 1, 2011 at 12:09 PM, XLS S <xlst...@gmail.com> wrote: > Hey Rajan Babu, > > which page? > > > > > > On Sat, Oct 1, 2011 at 11:52 AM, rajan verma <rajanverma1...@gmail.com>wrote: > >> HI, >> Please visit this Page to know more about Worksheet Events.. >> >> Regards >> Rajan >> >> On Sat, Oct 1, 2011 at 10:53 AM, Mr excel <excelkeec...@gmail.com>wrote: >> >>> HI group, >>> >>> This is a Great & amazing group in learning excel vba.. >>> >>> >>> *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel >>> As Boolean)* >>> >>> *Dim st As String* >>> >>> *Dim sh As Worksheet* >>> >>> *Set sh = Sheets("Sheet2")* >>> >>> *st = Target.Address* >>> >>> *sh.Activate* >>> >>> *sh.Range(st).Activate* >>> >>> *ActiveCell.Value = sh.Name & st* >>> *End Sub* >>> >>> I had a doubt regarding the above code. >>> I had taken a sample code from one of posts.What exactly does the code >>> in Brackets mean, and when will this type of code in brackets used.Can any >>> body explain me in detail with some easily understandable examples..I m a >>> beginner in excel vba... >>> Thanks in advance... >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- 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