using event Worksheet_Change excel

[SteIT]

I am using the event Worksheet_Change to trigger a macro when a value is enter in a range of cells (column J).

How can I run a different macro when a value is entered in a different column (column B).


Regards

SteIT

 

[SkipVought]

Hi,

if not intersect(target, activesheet.cells(1,"J").entirecolumn) is nothing then
  macro1
elseif not intersect(target, activesheet..cells(1,"B").entirecolumn) is nothing then
  macro2
end if

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[xlbo]

If target.column = 10 then
  'your code for changes in column J
elseif target.column = 2 then
  'your code for changes in column B
else
  'don't run code
end if

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question