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 doesnt 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 dont know if this
is possible in Excel€¦