View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PATS PATS is offline
external usenet poster
 
Posts: 17
Default Problem displaying a UserForm

Can anyone tell me why this code is not displaying my UserForm?

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("D7:Y7000")) Is Nothing Then
UserForm2.Show
End If


End Sub