Hi Rajan, Due to some reason I was unable to access internet so i could not check my emails.
I used the below codes and it is working fine. It was just an example to understand how to create user defined formulas in excel and make it permanent for any excel files. Thank you so much for time and help. Regards, Atul On Wed, Aug 17, 2011 at 1:55 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > Try this > > Function Result(a as double,b as double, x as double) as double > Result = (a*x)+ b > End Function > > Once you define any Public Function in VBA those are available to Use on > WOrkhseet , if you want to make this Function for application You can make > add-ins or you can also save this function in Personal Macro Workbook Code > Module, > > Hope it will heps > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Atul > Sent: Tuesday, August 16, 2011 11:04 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ User Defined formula in Excel > > Hi, > > Is there any way to defined a user defined formula in excel which will > work like default functions e.g. Sum, Average etc. > > Suppose I want to insert a formula to solve the equation y=ax+b > > So I will just give the value of a, b and x so it will return the > required value of Y and this function will be appear with pre-defined > functions (Sum, Average, Count). > > I hope any macro is possible to do this. > > Looking forward to hear from all excel gurus for this problem. > > Thanks! > > Regards, > Atul > > -- > > ---------------------------------------------------------------------------- > ------ > 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 > -- ---------------------------------------------------------------------------------- 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