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.

--

HTH

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

"Peter" wrote in message
...
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.

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)

"Peter" wrote in message
...
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.

Hi
use the worksheet_change event for this. See
http://www.cpearson.com/excel/events.htm

-----Original Message-----
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.
.