If you use data validation you can use the Worksheet_Change event to run a macro based on the selection,
but somewhere you'd have to layout what the possible scenarios are.

Any chance of you attaching a sample workbook indicative of what you're working with and trying to achieve?