title: How can I use an Enum for Validation in VBA
body: <p>I'm trying to add validation to a Cell but I would like to use an Enum as Source. </p>
  
  <pre><code> Public Enum account
  
        AA
        BB
        PP
        ZZ
  
    End Enum
  
    Sub Main()
  
      With Range("C9").Validation
          .Delete
          .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
               Operator:=xlBetween, Formula1:= ...
  
    End With
  End Sub     
  </code></pre>
  
  <p>Normally I would put <code>Join(account, ",")</code> if account would be an array, but for an Enum it doesn't work. And if direct usage of Enum is not possible how can I add enum values to an array?</p>