Drop down list to trigger a macro

**HraHuuh** · 07-11-2012, 06:15 AM

Hey all!
Ive problem with code. I have two form control drop down lists. I want that if value of one of those drop down lists has changed it will trigger a macro. Ive been trying to do with cell link. when the value of cell is changed it will run the macro. I tried to do that with Worksheet_change but it didnt work. I paste my workbook here and if somebody could show me how does it work

thank you very much in advance!

**Steffen Thomsen** · 07-11-2012, 06:58 AM

Hi,

If you write the macro with what need to happen then you can assign the macro to the drop down control.

Right click the drop down and in the menu press "Assign macro". This macro fires when a selection is made in the drop down.