This thread had exactly what I needed to run the macro from a drop down list.

http://www.excelforum.com/excel-prog...down-menu.html

But I can not get it to work on multiple lists on the same sheet as it is locked to the one cell, any ideas or what changes to the code I need to make? I would need it to run on 4 dif cells.

Thanks,