Linking macros to items in a drop down list

Hello cweicker
You don't give any info about your data layout or what you want your macros to do etc. so its impossible to be too specific.
The attached will give you a general structure to link your dropdown values to VBA.
I have just used a message box to test so you will need to replace this with your functional code.