macro's

[stilgar]

i've got a heap of different macro's currently setup so when i click a button it runs all of them.

what i want is for them to run every time a change is made to a cell. such as a new selection from a drop down menu or a new value entered.

any help would be great as i'm still learning vb

 

[jim may]

Look into the Worksheet_Change Event capabilities (in Help).