Private toto As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not toto Is Nothing Then toto.Value = Replace(toto.Value, "*", "x") End If Set toto = Target End Sub
Private toto As String, couic As Boolean Private Sub Worksheet_Change(ByVal Target As Range) If toto = "" Then MsgBox "coucou" End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If toto <> "" Then If Not couic Then Range(toto).Value Replace(Range(toto).Value, "*", "x"): toto "": couic = True ': Exit Sub End If DoEvents Else If Not InStr(Target.Value, "*") Then couic False: toto Target.Address: Exit Sub End If End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question