title: Excel VBA - Set values of Enumerated elements
body: <p>In a Class Module there is:</p>
  
  <pre><code>Private Enum colType
      ID = "A"
      SSN = "B"
      lName = "H"
      fName = "G"
  End Enum
  </code></pre>
  
  <p>as a private member.  Whenever the class initializes I get the  <strong>Compile Error: Type Mismatch</strong> message.  If I declare <code>colType</code> as <code>Private Enum coltype As String</code>.  That gets highlighted red as an error and I get the message:</p>
  
  <blockquote>
    <p><strong>Compile Error: Expected end of statement</strong></p>
  </blockquote>
  
  <p>Is specifying the values of enumerated elements Unallowed in Excel VBA?</p>