I just started VBA and I\'m just making simple functions, but when I try to call

Question

I just started VBA and I'm just making simple functions, but when I try to call my function in Excel it gives me, "Compile Error: Argument not optional" and highlights my Function and the Cos.

'Functions "sec1" and "tan1" validate the trigonometric relation tan^2(theta) = sec^2(theta) - 1
Function sec1(theta As Double) As Double

sec1 = ((Cos) ^ -1) * (theta ^ 2) - 1

End Function
But, my other trig functions work fine like this one: Function sin1(theta As Double) As Double
sin1 = 1 - Cos(theta) ^ 2
End Function Any help would be appreciated. 'Functions "sec1" and "tan1" validate the trigonometric relation tan^2(theta) = sec^2(theta) - 1 End Function
But, my other trig functions work fine like this one: Function sin1(theta As Double) As Double
sin1 = 1 - Cos(theta) ^ 2
Function sin1(theta As Double) As Double
sin1 = 1 - Cos(theta) ^ 2
End Function Any help would be appreciated.

Explanation / Answer

The disadvantage of Excel's 'user defined functions' is that they can only return a single value, and the function cannot alter the properties of the worksheet. Arguments you pass to the VBA functions you define are passed 'by value'.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.