Worksheet / Workbook Change Property

P

Peter

Hi
does anyone know if there is a way of automatically
checking to see if a named range within a worksheet has
been changed and then running some VB behind it? What I'm
think is define a range name, put something in it, exit
the cell and that's when the code kicks in. Almost like
an ControlName_OnChange or ControlName_OnExit VB type
call.

I've tried a couple of things but can't get it to work.

Thanks in advance for any replies.
 
B

Bob Phillips

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Peter,

There is no NameChange even t, but as it is the value that will change, it
the name refers to a worksheet range, you can use the Worksheet_CHnage event
to monitor it and react.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top