Hi Everybody!!!!

I need some help with a solution for running a macro that I recorded.
Just so you know recording macros is about the limit of my VBA
knowledge.

Here's my problem!!!!!
Right now I have a shortcut of ctrl f that triggers my Macro. I would
like to trigger the macro when specific cells in sheet 3 are changed.

I want to run a macro if cells $K$3, or $J$3, or $E$10, or $E$11
are changed, changed in any way (no criteria)

example:
If $K$3 is changed from true to false by a check box 83
or if $E$10 is changed from blank to "lumber" by way of Data validation
list or $E$11 is Changed from "steel" to blank

all of these events should run my macro

For your information

$K$3 is linked to Forms check box 83

$J$3 is linked to Forms checkbox 86

$E$10 has a data valitdation list in it

$E$11 has a data valitdation list in it

also I need the macro to be triggered upon entering sheet3

the macro is in module #2 and is called Macro2

Thanks for any help in advance it is really appreciated


--
mav93
------------------------------------------------------------------------
mav93's Profile: http://www.excelforum.com/member.php...o&userid=31592
View this thread: http://www.excelforum.com/showthread...hreadid=516220