Run Excel VBA module for all the values of a Combo Box

I want to run a macro in Excel 2010 that uses each of the values in a combo box automatically until all the values in the combo box have been run.

For example if the combo box has the values 1,2,3,4 the code should run for each of these values passing them into a macro.