title: SImplifying if statements
body: <p>I'm making a VBA-project and want to simplify the following if-statements, because i need to this following 11 times more, for each person.</p>
  
  <pre><code>'CTK opportunities
  If result = "CTK" And ToggleButton1 = True Then Range("B4").Value = "X"
  If result = "CTK" And ToggleButton2 = True Then Range("C4").Value = "X"
  If result = "CTK" And ToggleButton3 = True Then Range("D4").Value = "X"
  If result = "CTK" And ToggleButton4 = True Then Range("E4").Value = "X"
  If result = "CTK" And ToggleButton5 = True Then Range("F4").Value = "X"
  If result = "CTK" And ToggleButton6 = True Then Range("G4").Value = "X"
  If result = "CTK" And ToggleButton7 = True Then Range("H4").Value = "X"
  If result = "CTK" And ToggleButton8 = True Then Range("I4").Value = "X"
  If result = "CTK" And ToggleButton9 = True Then Range("J4").Value = "X"
  If result = "CTK" And ToggleButton10 = True Then Range("K4").Value = "X"
  If result = "CTK" And ToggleButton11 = True Then Range("L4").Value = "X"
  If result = "CTK" And ToggleButton12 = True Then Range("M4").Value = "X"
  
  'Next person
  </code></pre>