Set Cel = Worksheets("gestionnaire de taches").Columns("B").Find(what:=Me.ComboBox5, LookIn:=xlValues, lookat:=xlWhole) If Not Cel Is Nothing Then ligne = Cel.Row If MsgBox("Voulez-vous modifier les informations du n° ID " & Me.ComboBox5 & " ?", _ vbQuestion + vbYesNo, "Modification") <> vbYes Then Exit Sub End If Worksheets("gestionnaire de taches").Range("T" & ligne) = TextBox1
Set Cel = Worksheets("gestionnaire de taches").Columns("B").Find(what:=Me.ComboBox5, LookIn:=xlValues, lookat:=xlWhole) If Not Cel Is Nothing Then ligne = Cel.Row If MsgBox("Voulez-vous modifier les informations du n° ID " & Me.ComboBox5 & " ?", _ vbQuestion + vbYesNo, "Modification") <> vbYes Then Exit Sub Worksheets("gestionnaire de taches").Range("T" & ligne) = TextBox1 ELSE MsgBox "Aucun résultat !" End If
Dim f As Worksheet, plage As Range
Private Sub ComboBox5_Click()
MsgBox f.Cells(ComboBox5.ListIndex + plage.Row, 7)
End Sub
Private Sub UserForm_Initialize()
Set f = Worksheets("gestionnaire_de_taches")
lg = f.Range("B" & Rows.Count).End(xlUp).Row
Set plage = f.Range("b5:b" & lg)
ComboBox5.RowSource = f.Name & "!" & plage.Address
End Sub
Dim f As Worksheet, plage As Range
Private Sub ComboBox5_Click()
MsgBox f.Cells(ComboBox5.ListIndex + plage.Row, 7)
End Sub
Private Sub UserForm_Initialize()
Set f = Worksheets("gestionnaire_de_taches")
lg = f.Range("B" & Rows.Count).End(xlUp).Row
Set plage = f.Range("b5:b" & lg)
ComboBox5.RowSource = f.Name & "!" & plage.Address
End Sub
Private Sub annuler_Click()
planificator.Hide
End Sub
Private Sub enregistrer2_Click()
Dim ligne As Long
Dim Cel As Range
Set Cel = Worksheets("gestionnaire de taches").Columns("B").Find(what:=Me.ComboBox5, LookIn:=xlValues, lookat:=xlWhole)
If Not Cel Is Nothing Then
ligne = Cel.Row
If MsgBox("Voulez-vous modifier les informations du n° ID " & Me.ComboBox5 & " ?", _
vbQuestion + vbYesNo, "Modification") <> vbYes Then Exit Sub
End If
Worksheets("gestionnaire de taches").Range("T" & ligne) = TextBox1
Unload Me
End Sub
Private Sub UserForm_Initialize()
Dim f As Worksheet, plage As Range
Set f = Worksheets("gestionnaire_de_taches")
lg = f.Range("B" & Rows.Count).End(xlUp).Row
Set plage = f.Range("b5:b" & lg)
ComboBox5.RowSource = f.Name & "!" & plage.Address
End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim toto As Long
toto = 123
MsgBox "alors" & toto ' ===>> alors123 (correct)
MsgBox "alors" & Str(toto) ' ===>> alors 123 (incorrect)
22 déc. 2014 à 16:12