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.