Hello can anyone please help, I have started the assignments, but am a little confused, what i need is 9 option buttons: at the buttom i have enclosed the code i have written please have a look and please help,
If the user enters option 1, it should make option 4 and option 7 not available
If the user enters option 2, it should make option 5 and option 8 not available, but make rest of the option available
If the user enters option 3, it should make option 6 and option 9 not available, but make rest of the option available
If the user enters option 4, it should make option 1 and option 7 not available, but make rest of the option available
If the user enters option 5, it should make option 2 and option 8 not available, but make rest of the option available
If the user enters option 6, it should make option 3 and option 9 not available, but make rest of the option available
If the user enters option 7, it should make option 1 and option 4 not available, but make rest of the option available
If the user enters option 8, it should make option 2 and option 5 not available, but make rest of the option available
If the user enters option 9, it should make option 3 and option 6 not available, but make rest of the option available
As you can see from my code, I have used the command enable, but it the user presses option 9 it will not allow him to choose option 3 and option 9, but how can I make it work for all of them please help me.
Private Sub Command1_Click()
Dim TEST(5) As String
TEST(1) = "EKMFLGDQVZNTOWYHXUSPAIBRCJ"
TEST(2) = "AJDKSIRUXBLHWTMCQGZNPYFVOE"
TEST(3) = "BDFHJLCPRTXVZNYEIWGAKMUSQO"
If Option1 = True Then
Text1.Text = TEST(1)
Option4.Enabled = False
Option7.Enabled = False
End If
If Option2 = True Then
Text1.Text = TEST(2)
Option5.Enabled = False
Option8.Enabled = False
Else:
Option4.Enabled = True
Option7.Enabled = True
End If
If Option3 = True Then
Text1.Text = TEST(3)
Option6.Enabled = False
Option9.Enabled = False
Else:
Option5.Enabled = True
Option8.Enabled = True
End If
If Option4 = True Then
Text2.Text = TEST(1)
Option1.Enabled = False
Option7.Enabled = False
Else:
Option6.Enabled = True
Option9.Enabled = True
End If
If Option5 = True Then
Text2.Text = TEST(2)
Option2.Enabled = False
Option8.Enabled = False
Else:
Option1.Enabled = True
Option7.Enabled = True
End If
If Option6 = True Then
Text2.Text = TEST(3)
Option3.Enabled = False
Option9.Enabled = False
Else:
Option2.Enabled = True
Option8.Enabled = True
End If
If Option7 = True Then
Text3.Text = TEST(1)
Option1.Enabled = False
Option4.Enabled = False
Else:
Option3.Enabled = True
Option9.Enabled = True
End If
If Option8 = True Then
Text3.Text = TEST(2)
Option2.Enabled = False
Option5.Enabled = False
Else:
Option1.Enabled = True
Option4.Enabled = True
End If
If Option9 = True Then
Text3.Text = TEST(3)
Option3.Enabled = False
Option6.Enabled = False
Else:
Option2.Enabled = True
Option5.Enabled = True
End If
End Sub