How do you use a .NET Enum through Excel Automation Add-In UDFs ?

[pinkfloydfan]

Hi there

I have a C# class that I have loaded as an Automation Add-In for
Excel. The functions work absolutely fine in Excel but there is an
interesting problem when one of the parameters is an Enum which I hope
that someone here will be able to explain to me:

1) If I input the number corresponding to the Enum parameter (e.g. 0)
I want to use into the function parameter it works as expected
2) If I type the name/string of the Enum parameter I want to use again
it works but it always assumes the Enum parameter is 0
3) If I reference a cell with either the name or number of the Enum
parameter I get a #VALUE! error

So, does anybody know why this happens? And even better can anybody
tell me what I need to add to my code so that the user can write the
name of the Enum parameter or a reference to a cell with it directly
into the function parameter and have the UDF work?

Many Thanks
Lloyd