title: Defining variable names using other variables in VBA
body: <p>I'm fairly new to VBA, and have the following situation from a basic training exercise:</p>
  
  <pre><code>Select Case Me.comColour
      Case Is = "Red"
      Range("a1").Font.Color = vbRed
      Case Is = "Blue"
      Range("a1").Font.Color = vbBlue
      Case Is = "Green"
      Range("a1").Font.Color = vbGreen
  End Select
  </code></pre>
  
  <p>Now, given that the combobox only contains the words Red, Green, Blue, it occurred to me that perhaps I could call vb(colour) directly in some manner by saying something like "evaluate vb followed by Me.comColour"</p>
  
  <p>I know I can do this in mIRC scripting to define variables with different names based on other variables (for instance creating %variable1, %variable2, etc as needed) using the format </p>
  
  <pre><code> [ % $+ stuff $+ [ %variable ] ]
  </code></pre>
  
  <p>but how would I do this in VBA?</p>