Private Sub Command16_Click() If Combo1.Text = "game one" Then 'combo1 est OK Form1.Show Form8.Hide Else 'combo1 est KO If Combo2.Text = "game two" Then 'mais combo2 OK Form2.Show Form8.Hide Else 'et combo2 KO aussi MsgBox "Please choose a game first", vbCritical, "Choice missing" End If End If End Sub
Private Sub Command1_Click() If Combo1.Text = "game one" Then Form2.Show Form1.Hide Else If Combo2.Text = "game two" Then Form2.Show Form1.Hide Else MsgBox "Please choose a game first", vbCritical, "Choice missing" End If End If If Combo1.Text = "game three" Then Form2.Show Form1.Hide Else If Combo2.Text = "game four" Then Form2.Show Form1.Hide Else MsgBox "Please choose a game first", vbCritical, "Choice missing" End If End If End Sub
Private Sub Form_Load() Combo1.AddItem "game one" Combo2.AddItem "game two" Combo1.AddItem "game three" Combo2.AddItem "game four" End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question1) Pourquoi mettre 2 combo alors qu'une seule suffit
2) Utilise Select Case pour résoudre ton problème
voit ton aide en ligne
Private Sub Command1_Click() If Combo1.Text " game one" Or Combo2.Text " game one" Or Combo1.Text = " game two" Or Combo2.Text = " game two" Then Form2.Show Form1.Hide Else MsgBox " Please choose a game first", vbCritical, " Choice missing" End If End Sub Private Sub Form_Load() Combo1.AddItem "game one" Combo2.AddItem "game one" Combo1.AddItem "game two" Combo2.AddItem "game two" End Sub
Private Sub Command1_Click() If Combo1.Text "game one" Or Combo2.Text "game one" Or Combo1.Text = "game two" Or Combo2.Text = "game two" Then Form2.Show Form1.Hide Else MsgBox " Please choose a game first", vbCritical, " Choice missing" End If End Sub Private Sub Form_Load() Combo1.AddItem "game one" Combo2.AddItem "game one" Combo1.AddItem "game two" Combo2.AddItem "game two" End Sub
select case Combo1.Text case "game one", "game two" Form2.Show: Form1.Hide case else select case Combo2.Text case "game one", "game two" Form2.Show: Form1.Hide case else MsgBox " Please choose a game first", vbCritical, " Choice missing" end select end select