Using Excel worksheet functions in VBA for complex numbers

[nleahcim]

Hi - I wrote this simple function:

Please Login or Register  to view this content.

But it does not seem to work. Specifically, when I call it from Excel, it just says "=VALUE?"

It seems to be related to my use of the complex functions. Maybe the complex functions use a unit that can only be handled in the worksheet and not VBA? I believe the brackets are the correct way of calling worksheet functions, but maybe that's causing a problem?

Thanks!!!

edit: more information, if useful:

I'm using Excel 2010.
I tried enabling both the "analysis toolpak" and the "analysis toolpak - vba" but neither helped. I added a reference to "ATPVBAEN.XLAM" to my VBA project. No dice. Removing the brackets gives me errors, so I think maybe the reference is not working? I know nothing about using references...
I ran across this page: http://www.excelbanter.com/showthread.php?t=304765 that talks about a potential solution to the problem, but honestly it's way over my head.
Without the brackets, I got errors. They do seem to work though for at least the Pi() function.

[protonLeah]

a) Fc=worksheetfunction.Complex(...
b) #? = WorksheetFunction.Pi

[nleahcim]

a) Fc=worksheetfunction.Complex(...
b) #? = WorksheetFunction.Pi

Hi! Adding "worksheetfunction." in front of all the complex functions worked great! Any idea why brackets work for pi() but not for the imaginary functions? I should mention I removed the reference to the analysis toolpak and disabled both analysis tookpaks, and everything still works great.

I don't understand your second suggestion though?

Anyways - thanks so much for the help!!

Fixed code is below for anybody in the future that happens upon this thread:

Please Login or Register  to view this content.