Userform to Show After Two Specific Cells Change

breynolds0431

Board Regular
Joined
Feb 15, 2013
Messages
61
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,185
What type of data do your named ranges contain, text or numerical values?
 

mrmmickle1

Well-known Member
Joined
May 11, 2012
Messages
2,453
You might try and put this Worksheet Change Event Code in the Worksheet Code Module:

Code:
[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]
 

Watch MrExcel Video

Forum statistics

Threads
1,099,790
Messages
5,470,793
Members
406,724
Latest member
BruceLee Nguyen

This Week's Hot Topics

Top