Worksheet / Workbook Change Property

  • Thread starter Thread starter Peter
  • Start date Start date
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.
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to reference a cell from anther workbook without opening it 0
Copy Multiple Areas from One Workbook to Another 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
How to hide password? 1
Duplicating worksheet based on range and changing worksheet name 3
How to copy worksheet template into multiple worksheets 1
using the same range name on different worksheets in a workbook 9
VBA code for pasting links -- modifying RDB code for summary workbook 10

Back
Top