How To: Excel user defined function with user defined argument constants/structures

Question

Hi to whom it may concern,

within Excel VBA, is it possible for a user defined function to provide predefined constant/structure values for the each potential declared argument, just like other internal VBA functions already do?

i.e. for illustration purposes, take say the VBA MsgBox function, we can see here for the 'Button' argument its default value is pre-set to vbOKOnly, but there's a provided list of argument constant/structure values that a user can select from.

... hence my question, can a user defined function replicate the same visual functionality but with a user defined list of constant/structure values in order to limit what a user can select?

Thankyou in advance.

Answer 1

Sure, it's a simple enum(eration)
https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/enum-statement

Public Enum enuTest  
    enuTest01 = 1  
    enuTest02 = 2  
End Enum  
  
Public Test()  
    Dim enu As enuTest  
      
    enu = enuTest01  
End