Userform to Show After Two Specific Cells Change

[breynolds0431]

Hello -

I am attempting to have a userform show after two specific cells are changed and to not show again when any other part of the workbook incurs a change. Below are the cell references to cause the userform to show:

Cell / Range Name 1: C4 / PROVFYB
Cell / Range Name 2: J4 / PROVFYE

Userform Name: Short

 

[Domenic]

What type of data do your named ranges contain, text or numerical values?

 

[breynolds0431]

Hi - They are actually both dates.

 

[mrmmickle1]

You might try and put this Worksheet Change Event Code in the Worksheet Code Module:

[COLOR=#0000ff]Private Sub[/COLOR] Worksheet_Change([COLOR=#0000ff]ByVal [/COLOR]Target[COLOR=#0000ff] As[/COLOR] Range)
[COLOR=#0000ff]    If [/COLOR]Target.Address = "$C$4" [COLOR=#0000ff]Or[/COLOR] Target.Address = "$J$4" [COLOR=#0000ff]Then[/COLOR]
        Short.Show
[COLOR=#0000ff]    End If[/COLOR]
[COLOR=#0000ff]End Sub[/COLOR]