title: Excel - Set values of Userform Checkboxes based on cell contents
body: <p>I'm developing a userform, one section of which contains three checkboxes referring to different parts of the world. Depending on the combination these enter a text value into cell C9.</p>
  
  <p>I want to have the checkboxes reflect what is in the cell already when the user goes back into the userform. I've been able to do this for every other item in the userform (option buttons, textboxes, comboboxes), but my checkboxes don't respond at all, they are simply unchecked when the userform appears, regardless of C9's value.</p>
  
  <p>The following code is in the userform_intialize module. Any ideas?</p>
  
  <pre><code>If wsM.Range("C9").Value = "EU-5" Then
          NABox.Value = False And EUBox.Value = True And RoWBox.Value = False
      ElseIf wsM.Range("C9").Value = "EU-5 &amp; RoW" Then
          NABox.Value = False And EUBox.Value = True And RoWBox.Value = True
      ElseIf Sheets("Menu").Range("C9").Value = "NA &amp; EU-5" Then
          NABox.Value = True And EUBox.Value = True And RoWBox.Value = False
      ElseIf wsM.Range("C9").Value = "North America" Then
          NABox.Value = True And EUBox.Value = False And RoWBox.Value = False
      ElseIf wsM.Range("C9").Value = "NA &amp; RoW" Then
          NABox.Value = True And EUBox.Value = False And RoWBox.Value = True
      ElseIf wsM.Range("C9").Value = "Rest of World" Then
          NABox.Value = False And EUBox.Value = False And RoWBox.Value = True
      Else: NABox.Value = False And EUBox.Value = False And RoWBox.Value = False
  End If
  </code></pre>
  
  <p>Thanks for any help.</p>