How can i get vba to get a value from a combobox and make it run a macro

[MelonFuel]

Hi

How can i get vba to do this.

When i click a button on the main form the vba code will execute and get the value from the combobox ie TE4700 and locate the macro with the same name ie TE4700 with reports in then it will run the macro and print off the reports.

Thanks MelonFuel