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

Reply via email to