Trigger VB code upon change in value of a cell

[desi5pure]

How can I trigger a VB code (to go to a particular tab) when someone picks a value from a dropdown in a cell? I have different tab for each value in the dropdown and would like to go to that particular tab when the value is picked.

 

[SkipVought]

Please post VBA questions in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[desi5pure]

I should have mentioned that this is in Excel (MS Office). I want to trigger VB code when someone picks a value from drop down.