Passing Enum values to Excel Function

[Tony Martin]

I'm writing an Excel UDF and would like to make it where valid values are presented to the user (Like VB does when you start typing a function there) OR let the user use descriptive names(like VB does with it's constants)

Here's a code paste:

Public Enum SheetTypes
st_Inventory_Adjusts = 0
st_Receipts = 1
st_Shipments = 2
End Enum


Public Function Sheet_Sum(ByVal eSheetType As SheetTypes, strCellName As String) As Long
.
.
.
.
end function

I get a dropdown when I use the function from within the VB editor, but I get nothing when I type the function in a spreadsheet cell. Not even a tooltip popup. (Although passing 0,1,2 work just fine)

Is there a way to either display the enum values like VB does, or have these be useable via named constant name?

Thanks!