Private Sub Worksheet_Change(ByVal Target As Range) Dim val As Integer If Not Intersect(Target, Range("e3:e10")) Is Nothing Then If Target.Rows.Count > 1 Then Exit Sub If Target.Value = "" Then Exit Sub val = Worksheets("Condizioni").Range("f" & Target.Row).Value Select Case val Case Is = 0 MsgBox "Immettere denominazione in DB" Case Is = 1 MsgBox "Denominazione già usata" Case Is = 2 MsgBox "Ok" End Select End If End Sub |