Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub AddNew_Click() Dim s As String Dim sRow As Integer s = MsgBox("Are You Sure", vbQuestion + vbYesNo, "Save...") If s = vbNo Then Exit Sub sRow = MSHFlexGrid1.Rows + 1 MSHFlexGrid1.Rows = sRow MSHFlexGrid1.TextMatrix(sRow - 1, 0) = sRow - 1 MSHFlexGrid1.TextMatrix(sRow - 1, 1) = TXT_PRES.Text MSHFlexGrid1.TextMatrix(sRow - 1, 2) = TXT_TIME.Text TXT_PRES.Text = "" TXT_TIME.Text = "" MsgBox "Data Has Saved Successfully", vbInformation, "Saved" End Sub Private Sub Command1_Click() Dim s As String s = MsgBox("Are You Sure", vbQuestion + vbYesNo, "Save...") If s = vbNo Then Exit Sub Dim sRow As Integer sRow = MSHFlexGrid1.Rows + 1 MSHFlexGrid1.Rows = sRow MSHFlexGrid1.TextMatrix(sRow - 1, 0) = sRow - 1 MSHFlexGrid1.TextMatrix(sRow - 1, 1) = "END" End Sub Private Sub EDIT_Click() If (MSHFlexGrid1.Row = 0) Then ' A = MsgBox("Impossible de modifier la ligne", vbCritical, "Erreur") ElseIf (TXT_PRES.Text Empty Or TXT_PRES.Text Empty) Then A = MsgBox("Un des champs desiré est vide donc impossible de modifier la ligne", vbCritical, "Erreur") Else MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1) = TXT_PRES.Text MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2) = TXT_TIME.Text TXT_PRES.Text = "" TXT_TIME.Text = "" End If End Sub Private Sub DELETE_Click() If MSHFlexGrid1.Rows = 1 Then Exit Sub If MSHFlexGrid1.Rows 2 And MSHFlexGrid1.Row 1 Then MSHFlexGrid1.Rows = 1 MSHFlexGrid1.Row = MSHFlexGrid1.Row - 1 Exit Sub End If MSHFlexGrid1.RemoveItem MSHFlexGrid1.Row End Sub Private Sub EXIT_Click() Dim p As String p = MsgBox("Are You Sure To Exit", vbQuestion + vbYesNo, "Exit...") If p = vbNo Then Exit Sub End End Sub Private Sub Form_Load() MSHFlexGrid1.TextMatrix(0, 0) = "Step n°" MSHFlexGrid1.TextMatrix(0, 1) = "Pressure" MSHFlexGrid1.TextMatrix(0, 2) = "Time" 'MSHFlexGrid1.Rows = MSHFlexGrid1.Rows + 5 End Sub