title: Returning 3 Values to post based linked radio Butten
body: <p>I have Created 3 Radio Buttons Card, Cash, EFT, but the script I write no matter  what i use populates an error I know IIF only returns two values but else does not work aswell.</p>
  
  <p>The issue is here Below</p>
  
  <p>.Range("G" &amp; iRow).Value = IIf(optCard.Value = True, "Card", "EFT")
   based on the above I need to add a 3rd selection for the two it works fine but what ever i add after seems to be meet with errors
  Please Help</p>
  
  <p>Please see the script below. </p>
  
  <p>Private Sub cmdSave_Click()</p>
  
  <pre><code>Application.ScreenUpdating = False
  
  Dim iRow As Long
  
  iRow = Sheets("Data").Range("A1048576").End(xlUp).Row + 1
  
  If ValidateForm = True Then
  
      With ThisWorkbook.Sheets("Data")
  
         .Range("A" &amp; iRow).Value = iRow - 1
         .Range("D" &amp; iRow).Value = txtValue.Value
         .Range("G" &amp; iRow).Value = IIf(optCard.Value = True, "Card", "EFT")
         .Range("B" &amp; iRow).Value = cmbAccount.Text
         .Range("E" &amp; iRow).Value = txtWeek.Value
         .Range("F" &amp; iRow).Value = txtRetailer.Value
         .Range("H" &amp; iRow).Value = txtDate.Value
  
      End With
      Call Reset
  Else
      Application.ScreenUpdating = True
      Exit Sub
  End If
  
      Application.ScreenUpdating = True
  </code></pre>
  
  <p>End Sub</p>