There is a simple mechanism for hooking up C/C++ enums to Excel. Use XLL_ENUM
, or XLL_ENUM_DOC
if you want have the enumerated value documented using the macro XLL.DOC
.
There is another way to do this now using a function called ENUM
. https://xll.codeplex.com/wikipage?title=Enum.