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.
xll add-in library 