A file I'm working on have several dropdown lists created by using the
validating option from the data menu. I haven't the possibility to change
this, its a file that is created automatically and will be recreated from
time to time which make such a change impossible to implement.

What I need to do is create a macro in an addin that is triggered if there
is a change in one of those dropdownlists. The lists contain only the words
Yes and No and I know where the cells containing the lists are located so it
shouldn't be hard but I'm not used to working with VBA lately.

I have a VBA sub which does what I want depending on the value from the cell
but how do I get the sub to be called?

Thanks for any help