Connecting macro from validating dropdown list
 

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

Connecting macro from validating dropdown list
 

Use the intersect method in the worksheet_change event


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35914