You would use a Worksheet_Change event macro. Within the macro, you would
write code to continue execution only when that specific cell's value
changes. Subsequent code would do what you want for the specific value
entered. Post back if you need further help with this. Include more detail
about what you have and what you want to happen. HTH Otto
"Keith" wrote in message
...
I have three pieces of code. Depending on the value of a specific cell I
want
one of these bits of code to run. The code doesn't assign a value to a
cell
but sets another cells validation list.

How can I get this code to run automatically? If it was Access I would
assign the code to the on change event of the field, but I don't know if
this
is possible in Excel.