title: VBA - Is there a way to get a Constant value from a variable String?
body: <p>I have created <strong>few Constants</strong> (VBA identifiers declared with the key word <code>Const</code>) that look like <code>Rg_Euro</code>, <code>Rg_Usd</code>, <code>Rg_Cad</code>, ... to define specific regions into my workbook.</p>
  
  <p>As I have these <strong>"extensions"</strong> (<strong><code>Euro</code>, <code>Usd</code>, <code>Cad</code>, ...</strong>) in the DataBase that I'm working with, <strong>I tried to get the values of my constant by creating a string</strong> like this : <code>Str = "Rg_" &amp; extension(i)</code></p>
  
  <p>But I <strong>can't seem to find a workaround to call the Constant and get its value from it...</strong> I'm googled it but didn't found what I was looking for and I'm starting to think that it might not be possible directly...</p>
  
  <p><em>I thought of a User Defined Function with a <code>Select Case</code> on the String to return the right value, but it is just going to add another function</em>, <strong>so I'm looking for a more direct solution if there is one!</strong></p>