Event macro

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

Hi Bigwheel,

The macro has a problem, the message is popping up when
any value is placed in any cell on the worksheet.

Can it activate only if values in the range of cells is
changed?

Thanks
 
Hi
use a statement like
if intersect(target,me.range("A1:B202")) is nothing then exit sub

at the beginning
 
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

Run Macro If Cell have "x" value 0
VBA set thick borders around non empty cells in range 0
Excel 2013 Merge Data 2
Combine 2 columns in a dynamic range into one 7
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Need Macro... 8
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Pasting cell contents into a macro 1

Back
Top