title: Which way is faster? If elseif or select case
body: <p>For the following code,</p>
  
  <pre><code>If Sheets("sheet1").Range("A1").Value = "option_1" Then
      Sheets("sheet1").Range("A1").Value = "option_2"
  ElseIf Sheets("sheet1").Range("A1").Value = "option_2" Then
      Sheets("sheet1").Range("A1").Value = "option_3"
  ElseIf Sheets("sheet1").Range("A1").Value = "option_3" Then
      Sheets("sheet1").Range("A1").Value = "option_4"
  ...
  End IF
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Select Case Sheets("sheet1").Range("A1").Value
      Case Is = "option_1"
          Sheets("sheet1").Range("A1").Value = "option_2"
      Case Is = "option_2"
          Sheets("sheet1").Range("A1").Value = "option_3"
      Case Is = "option_3"
          Sheets("sheet1").Range("A1").Value = "option_4"
      ...
  End Select
  </code></pre>
  
  <p>Questions:</p>
  
  <p>1) I am wondering which way would be faster. And if possible, tech detail could be explained?</p>
  
  <p>2) Regardless the efficiency, which method should I use in this case, for the better coding.</p>
  
  <p>3) Any other "simple" way to circle value from array?</p>