Dear Siti Thanks for Help.
shrinivas Date: Sat, 4 Sep 2010 14:59:51 +0700 Subject: Re: $$Excel-Macros$$ sumif kinda formula needed From: villager.g...@gmail.com To: excel-macros@googlegroups.com customized function ? in Excel we can create a function using VBA programming (1) open VBE / Visual Basic Editor: (alt + F11) (2) form menu: INSERT: Insert a standard module (3) write a Function procedur on in for example Function MyMultiply(FirstNum as Integer, SecondNum as integer) as Long MyMultiply = FirstNum * SecondNum End function go back to worksheet, and write a formula using this new function, [ also called as UDF (user defined function) ] =MyMultiply(5,150) this formula will returns 750 Of course, we can create a function with "high complexity", if we know the related case.. best regards, siti On Sat, Sep 4, 2010 at 11:37 AM, shrinivas shevde <shrinivas...@hotmail.com> wrote: > > Dear Stii > Thanks for help > Can u please answer my second question? > Can u insert a customised function in Excel ?If yes how? > > shrinivas > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
