Trigger Macros on ComboBox Selection

[jacobcurties]

Hello Everyone,

Please help me to trigger a macro according to the selection in the ComboBox.

Details:
ComboBox Values: Day Shift, Night Shift
Macro Names: DayShift, NightShift

Expected Result:
When "Day Shift" is selected, the active cell colour should go orange via macro "DayShift".
When "Night Shift" is selected, the active cell colour should go grey via macro "NightShift".

Managed to do the following:
Record Macro for the same and triggered the same according to the ComboBox selection.

Issue is:
When I select "Day Shift" the macro triggers successfully on the active cell. If I choose the same option "Day Shift" again on another cell immediately, nothing happens. However the macro works fine if I change the selection to "Night Shift" and come back to "Day Shift".

Any ideas ! Please let me know if I need to be more clear on the issue.