UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

[AwesomeSteph]

I have it so that the userform only shows when "XYZ" is selected from a drop down in B2.
But now even after it is satisfied if I select any other drop down in any other cell of this worksheet the userform opens again. I only want it to open if "XYZ" is selected from B4.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If [B2].Text = "XYZ" Then
UserForm.Show
With UserForm
  .StartUpPosition = 1
  .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
  .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
  .Show
End With
End If
Application.ScreenUpdating = True
End Sub

Any help is greatly appreciated!

 

[Fluff]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
[COLOR=#0000ff]If Target.Address <> "B2" Then Exit Sub[/COLOR]
If [B2].Text = "XYZ" Then
UserForm.Show
With UserForm
  .StartUpPosition = 1
  .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
  .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
  .Show
End With
End If
Application.ScreenUpdating = True
End Sub

 

[AwesomeSteph]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
[COLOR=#0000ff]If Target.Address <> "B2" Then Exit Sub[/COLOR]
If [B2].Text = "XYZ" Then
UserForm.Show
With UserForm
  .StartUpPosition = 1
  .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
  .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
  .Show
End With
End If
Application.ScreenUpdating = True
End Sub

This stopped the userform from opening at all.

 

[Fluff]

Is B2 a data validation dropdown?

 

[AwesomeSteph]

Is B2 a data validation dropdown?

Yes it is. There are a bunch of different options but I only want the userform if one option is chosen.

 

[Fluff]

Sorry, it should be

If Target.Address[COLOR=#ff0000](0,0)[/COLOR] <> "B2" Then Exit Sub

 

[AwesomeSteph]

That was the trick!! Thank you so much!!!

 

[Fluff]

You're welcome & thanks for the feedback