View Full Version : Disable userform.show
ddnron
08-28-2010, 08:04 AM
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
08-28-2010, 08:23 AM
I changed a cell outside my range and it activated the userform1, I'm do something wrong. Any suggestions? Thanks
Bob Phillips
08-28-2010, 08:36 AM
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
08-28-2010, 09:29 AM
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
08-28-2010, 10:09 AM
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
08-28-2010, 10:17 AM
Thanks xld - Works great!
Thanks for the quick reply. Enjoy your weekend!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.