title: Is there a way to get the enums in VBA?
body: <p>Is there a way to get the enums in VBA? Something like this example for C#, but for VBA?</p>
  
  <pre><code>using System;
  
  class EnumsExampleZ
  {
      private enum SiteNames
      {
          SomeSample = 1,
          SomeOtherSample = 2,
          SomeThirdSample = 3
      }
  
      static void Main()
      {
          Type enumType = typeof(SiteNames);
          string[] enumName = enumType.GetEnumNames();
  
          for (int i = 0; i &lt; enumName.Length; i++)
          {
              Console.WriteLine(enumName[i]);
          }
      }
  }
  </code></pre>
  
  <p>Lets say we have the following:</p>
  
  <pre><code>Enum FruitType
      Apple = 1
      Orange = 2
      Plum = 3
  End Enum
  </code></pre>
  
  <p>How can we display on the immediate window these:</p>
  
  <pre><code>Apple
  Orange
  Plum
  </code></pre>