Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem displaying a UserForm
Are you changing anything in that range, as against just selecting it?
-- __________________________________ HTH Bob "Pats" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem displaying a UserForm
Just selecting it
"Bob Phillips" wrote: Are you changing anything in that range, as against just selecting it? -- __________________________________ HTH Bob "Pats" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem displaying a UserForm
Another possibility... did you by any chance turn off events during your
coding session (either accidentally or on purpose)? Try executing this statement in the Immediate window and see if that straightens things out... Application.EnableEvents=True -- Rick (MVP - Excel) "Pats" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem displaying a UserForm
I also tried creating a general decleration module
Public bSELCTIONCHANGE As Boolean and adding the line : If bSELCTIONCHANGE Then to my code "Pats" wrote: Just selecting it "Bob Phillips" wrote: Are you changing anything in that range, as against just selecting it? -- __________________________________ HTH Bob "Pats" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem displaying a UserForm
Then try
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Target, Range("D7:Y7000")) Is Nothing Then UserForm2.Show End If End Sub -- __________________________________ HTH Bob "Bob Phillips" wrote in message ... Are you changing anything in that range, as against just selecting it? -- __________________________________ HTH Bob "Pats" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm not displaying | Excel Programming | |||
Displaying Userform | Excel Programming | |||
Displaying a Userform | Excel Programming | |||
Displaying one userform from another | Excel Programming | |||
PROBLEM DISPLAYING USERFORM | Excel Programming |