Disable userform.show

[ddnron]

Do not display the userform if I use clear contents in the range. Any suggustions on what code to use. Thanks


Private Sub Worksheet_Change(ByVal Target As Range)
Dim Vrange As Range
Set Vrange = Range("r2:t10")

UserForm1.Show
End Sub

[ddnron]

I changed a cell outside my range and it activated the userform1, I'm do something wrong. Any suggestions? Thanks

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Vrange As Range
Set Vrange = Range("r2:t10")
If Not Intersect(Target, Vrange) Is Nothing Then
UserForm1.Show
End If
End Sub

[ddnron]

Thanks for the reply XLD.
Works fine when not in range, no userform1 displays.
When I use clear contents in my range, the user form appears.
I only need the user form to appear, when i enter data.

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Vrange As Range
Set Vrange = Range("r2:t10")
If Not Intersect(Target, Vrange) Is Nothing Then
If Target.Value <> "" then
UserForm1.Show
End If
End If
End Sub

[ddnron]

Thanks xld - Works great!

Thanks for the quick reply. Enjoy your weekend!