Private Sub Text1_Change() Dim FIRST_SNAPSHOT_OFFSET As Long Dim SECOND_SNAPSHOT_OFFSET As Long Dim length As Long FIRST_SNAPSHOT_OFFSET = InStr(1, Text1.Text, ",", vbBinaryCompare) If FIRST_SNAPSHOT_OFFSET <> 0 Then SECOND_SNAPSHOT_OFFSET = InStr(FIRST_SNAPSHOT_OFFSET + 1, Text1.Text, ",", vbBinaryCompare) If SECOND_SNAPSHOT_OFFSET <> 0 Then MsgBox "Two snapshots in the same text ! It's forbidden !", vbCritical length = Len(Text1.Text) Text1.Text = Left$(Text1.Text, SECOND_SNAPSHOT_OFFSET - 1) & Right$(Text1.Text, length - SECOND_SNAPSHOT_OFFSET) End If End If End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question