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 wrote:
> Hi Rajan,
>
> Due to some reason I was
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
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
