Simple User-Defined Function

[JonElCanche]

I have created a UDF to calculate the Economic Order Quantity with the given inputs being Annual Demand, Order Costs, and Holding Costs. The formula works because I know the required inputs, but in Excel if i use the formula, =EOQ(, it allows me to enter inputs but does not say what inputs are required. I would like it to act as the DATE formula for example, prompting the user for the year, month, day. Below is the code in the module:

Function EOQ(AnnualDemand, OrderCost, HoldingCost)

    EOQ = Sqr(2 * AnnualDemand * OrderCost / HoldingCost)
    
     
      
End Function
[code]


-- removed inline image ---

 

[Blade Hunter]

I have posted this question myself before and I would be keen to see if anyone has a solution.

 

[Arul.rajesh]

If you are using excel 2010 you might want to look at "Application.MacroOptions"

It can provide help only if the user uses the insert function dialogbox

 

[JonElCanche]

If you are using excel 2010 you might want to look at "Application.MacroOptions"

It can provide help only if the user uses the insert function dialogbox

I am using Excel 2007

 

[Blade Hunter]

Awesome Arul, thanks so much

 

[Arul.rajesh]

I am using Excel 2007

Its a little tricky but you might want to take a look at this.

http://www.jkp-ads.com/articles/RegisterUDF01.asp
http://www.bettersolutions.com/excel/EIK284/YN723710331.htm

Blade,

Nice to hear it worked for you.

 

[JonElCanche]

Just to clarify, I would like my UDF to pop up and display the inputs required like in the=sum function, number1,number2...
-- removed inline image ---

 

[shg]

You can't get a UDF to show tooltips like native functions do. I think the possible options have all been suggested.