| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom functions using arguments with same name
that's a better idea, i'll try it thanks.
"Tom Ogilvy" wrote: You mean you want to have function named retailprice and a variable named retailprice. Without testing, I suspect you will get an error in the place where you use it as a variable if the function definition is within scope. Sounds like a bad idea to me. Why not fncRetailprice varRetailprice or something like that. -- Regards, Tom Ogilvy "Spencer Hutton" wrote in message ... what happens if i want to use something called RetailPrice as an argument in another function. "Tom Ogilvy" wrote: Public Function RetailPrice(arg1) Dim Cost as Double end Function Public function ProfitMargin(arg1) Dim Cost as Double End Function the value of cost in either function is unrelated to the value of cost in the other function. The same for Arg1 -- Regards, Tom Ogilvy "Spencer Hutton" wrote in message ... I have written some functions in VBA to calculate profit margin, cost and suggested retail price. they are simple in that the RETAILPRICE function has two arguments, COST and MARGIN. i am also using an argument named COST in the PROFITMARGIN function. how can i get VBA to recognize these as seperate variables? do i have to put them in separate modules? or is there a certain way i need to declare the variables? thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Errors on Functions with many arguments | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Need know what are valid SUMPRODUCTS arguments and functions | Excel Worksheet Functions | |||
| Arguments of Excel functions | Excel Programming | |||
| Arrays as Arguments in Functions | Excel Programming | |||
Threaded Mode
