Need help in Excel VBA creating custom functions.?

Question

I'm trying to create a custom function to use in my excel spreadsheet. I've search the net and can't seem to find the right answers. Copied some examples from a book but that still didn't solve my problem. Please help.

I want to create a custom function to calculate sales tax. something like =CA(AmountPurchase)

I tried doing:
Function = CA(7.5, Cost)
CA = ((7.5) * Cost)
End Function

However, it keeps showing me an error.

Please help.

HeadScratcher98 · Accepted Answer

Your troubles are over.

From the Excel menu bar, click Tools/Macro/Visual Basic Editor.

In the VB Editor, clikc Insert/Module, and you'll get Module1.

At the top you'll see Option Explicit.  Skip a line (blank) and type the following:

Public Function SalesTax(sglCost As Single) As Single
SalesTax = sglCost * 0.075
End Function

Go back to the worksheets.  Type "10" (without the quote marks) in a cell.  In the cell next to it, type "=SalesTax(A1)" (without the quote marks).  You should get 0.75.

That's the basics of how to do it.  Tweak it to suit your needs.

stairs · Answer

you need to use Excel applications by using using here syntax in VBA, right it incredibly is an occasion of the 'Sum' function, an identical utilized to the different geared up in Excel applications application.WorksheetFunction.Sum(Rang...

Blackened · Answer

you need to create the function in visual basic, I believe.

http://office.microsoft.com/en-us/excel/HA010548461033.aspx?pid=CL100570551033

In your case the function would go like this:

Function  GetTax(Tax,Cost)
GetTax=(Tax/100)*Cost
End Function

Trending News

Need help in Excel VBA creating custom functions.?

3 Answers