Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions.
@Rajesh please correct me if i m wrong. ________________________________ From: gurumurthy sastry Kondury <gurumurthy.sas...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, 4 January, 2011 10:31:34 AM Subject: Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is "to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) ", then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra <rajafs...@gmail.com> wrote: hi Group, > >i want to show description of the Function while using the same in Excel like >below screen shot. > > >e.g while using if function in excel it displays like > >=if(logical_test, value_if_true, value_if_false) > >thanks > >Rajesh Mahapatra -- >---------------------------------------------------------------------------------- > >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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts