I have the following code in a standard code Module:
Code: Select all
Public Enum bxAnalysis
bxMINERALOGY = 1
bxALUMINA = 2
bxIRON = 4
bxSILICA = 8
bxCOMPLETE = 15
bxLABELS = 16
bxIntermediate = 32
bxTranspose = 64
End Enum
Function bauxiteAnalysis(ta As Double, _
aa As Double, _
:
Optional resultType As bxAnalysis = bxCOMPLETE)
Dim resultCol As integer
If resultType And bxLABELS Then resultCol = 2 Else resultCol = 0
:
End Function
Can the enumeration type be exposed so that the user can select ?
Regards
Kevin