IF statement covering 2 textboxes

tigerdel

New member
Joined
Aug 23, 2012
Messages
40
Reaction score
0
Points
0
Location
Cambridgeshire
Excel Version(s)
Office 365
I have coded 2 textboxes to check for specific criteria and return results based on the state aof an option button.

However, only one of them works {the first one - if I switch them around it is always the first statement that works}

Grateful for some ideas to cure this:

Code:
If (optQ5_Result.Value = True Or optQ6_result.Value = True) Then
txtBasic.Value = "Yes"
Else
txtBasic.Value = "No"
If (OptQ1_Result.Value = True Or OptQ2_Result.Value = True Or OptQ3_Result.Value = True Or OptQ4_Result.Value = True) Then
txtArab.Value = "Yes"
Else
txtArab.Value = "No"

 
Last edited:

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Code:
If (optQ5_Result.Value = True Or optQ6_result.Value = True) Then
    txtBasic.Value = "Yes"
Else
    txtBasic.Value = "No"
End If

If (OptQ1_Result.Value = True Or OptQ2_Result.Value = True Or _
    OptQ3_Result.Value = True Or OptQ4_Result.Value = True) Then
    txtArab.Value = "Yes"
Else
    txtArab.Value = "No"
End If
 
Top