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