Hey Atul, Please find the below links,
http://www.ozgrid.com/VBA/Functions.htm http://www.codeproject.com/KB/macros/excelmvf.aspx http://www.vertex42.com/ExcelArticles/user-defined-functions.html On Tue, Aug 23, 2011 at 11:42 PM, Atul vishwakarma <atulkuma...@sify.com>wrote: > 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 > -- ......................... -- ---------------------------------------------------------------------------------- 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