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