Hi all,

I have a two drop down menus created using forms the 'combo box' where one
refers to the other list. So if you were to select "a" in the first drop down
menu then in the second menu it will only show 1,2,3 where as if you select
"b" then you will only have the options to select 4,5,6.

As well as this i also require for each option selected i.e if you select
"a" in menu 1 then you have 1,2,3 in menu 2 showing and when you select any
of the options it runs a different macro which has already been created.