Dim Resultat As Range
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question'Modification container Private Sub CommandButton1_Click() Dim cel As Range, lig&, i& If TextBox1 + TextBox2 + Label2 + TextBox3 <> "" Then Set cel = Feuil11.Range("A2:A" & Feuil11.Range("A" & Rows.Count).End(xlUp).Row).Find(TextBox1 + TextBox2 + Label2 + TextBox3, , , xlWhole) If Not cel Is Nothing Then lig = cel.Row Else MsgBox "Aucune correspondance trouvée", , "Pas de correspondance": Exit Sub 'Resultat.TextBox4 = Feuil11.Cells(lig, 1) 'Resultat.TextBox5 = Feuil11.Cells(lig, 1) 'Resultat.TextBox6 = Feuil11.Cells(lig, 1) 'Resultat.TextBox7 = Feuil11.Cells(lig, 2) 'Resultat.TextBox8 = Feuil11.Cells(lig, 2) 'Uerform3.MultiPage1.Pages("page1").ComboBox1.Value = Feuil11.Cells(lig, 3) 'Me.ComboBox2.Value = Feuil11.Cells(lig, 4) Resultat.TextBox18 = Feuil11.Cells(lig, 5) Resultat.TextBox146 = Feuil11.Cells(lig, 6) Resultat.ComboBox3 = Feuil11.Cells(lig, 7) Resultat.TextBox10 = Feuil11.Cells(lig, 8) Resultat.ComboBox5 = Feuil11.Cells(lig, 9) Resultat.ComboBox6 = Feuil11.Cells(lig, 10) Resultat.ComboBox7 = Feuil11.Cells(lig, 11) Resultat.ComboBox8 = Feuil11.Cells(lig, 12) Resultat.TextBox20 = Feuil11.Cells(lig, 13) Resultat.TextBox61 = Feuil11.Cells(lig, 14) Resultat.Show End If End Sub
If Not cel Is Nothing Then lig = cel.Row Else MsgBox "Aucune correspondance trouvée", , "Pas de correspondance": Exit Sub
Resultat.TextBox18 = Feuil11.Cells(lig, 5)
'Modification container Private Sub CommandButton1_Click() Dim cel As Range, lig&, i& If TextBox1 + TextBox2 + Label2 + TextBox3 <> "" Then Set cel = Feuil11.Range("A2:A" & Feuil11.Range("A" & Rows.Count).End(xlUp).Row).Find(TextBox1 + TextBox2 + Label2 + TextBox3, , , xlWhole) If Not cel Is Nothing Then lig = cel.Row Else MsgBox "Aucune correspondance trouvée", , "Pas de correspondance": Exit Sub 'UserForm3.TextBox4 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox5 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox6 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox7 = Feuil11.Cells(lig, 2) 'UserForm3.TextBox8 = Feuil11.Cells(lig, 2) UserForm3.ComboBox1 = Feuil11.Cells(lig, 3) UserForm3.ComboBox2 = Feuil11.Cells(lig, 4) UserForm3.TextBox18 = Feuil11.Cells(lig, 5) UserForm3.TextBox146 = Feuil11.Cells(lig, 6) UserForm3.ComboBox3 = Feuil11.Cells(lig, 7) UserForm3.TextBox10 = Feuil11.Cells(lig, 8) UserForm3.ComboBox5 = Feuil11.Cells(lig, 9) UserForm3.ComboBox6 = Feuil11.Cells(lig, 10) UserForm3.ComboBox7 = Feuil11.Cells(lig, 11) UserForm3.ComboBox8 = Feuil11.Cells(lig, 12) UserForm3.TextBox20 = Feuil11.Cells(lig, 13) UserForm3.TextBox61 = Feuil11.Cells(lig, 14) UserForm5.Hide End If End Sub
'Modification container Private Sub CommandButton1_Click() Dim cel As Range, lig&, i& If TextBox1 + TextBox2 + Label2 + TextBox3 <> "" Then Set cel = Feuil11.Range("A2:A" & Feuil11.Range("A" & Rows.Count).End(xlUp).Row).Find(TextBox1 + TextBox2 + Label2 + TextBox3, , , xlWhole) If Not cel Is Nothing Then lig = cel.Row Else MsgBox "Aucune correspondance trouvée", , "Pas de correspondance": Exit Sub 'UserForm3.TextBox4 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox5 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox6 = Feuil11.Cells(lig, 1) 'UserForm3.TextBox7 = Feuil11.Cells(lig, 2) 'UserForm3.TextBox8 = Feuil11.Cells(lig, 2) UserForm3.ComboBox1 = Feuil11.Cells(lig, 3) UserForm3.ComboBox2 = Feuil11.Cells(lig, 4) UserForm3.TextBox18 = Feuil11.Cells(lig, 5) UserForm3.TextBox146 = Feuil11.Cells(lig, 6) UserForm3.ComboBox3 = Feuil11.Cells(lig, 7) UserForm3.TextBox10 = Feuil11.Cells(lig, 8) UserForm3.ComboBox5 = Feuil11.Cells(lig, 9) UserForm3.ComboBox6 = Feuil11.Cells(lig, 10) UserForm3.ComboBox7 = Feuil11.Cells(lig, 11) UserForm3.ComboBox8 = Feuil11.Cells(lig, 12) UserForm3.TextBox20 = Feuil11.Cells(lig, 13) UserForm3.TextBox61 = Feuil11.Cells(lig, 14) UserForm5.Hide End If End Sub