Select a specific value from the dropdown list and automatically diverted to another tab

[alice2011]

Dear all,

I have a sample file here (attached). What I want to achieve is:

If "TEK 3" is selected from the dropdown box in tab "Model_A", then it will automatically divert user to tab "Model_B". Otherwise, nothing will happen and the user continues to stay on tab "Model_A".

I hope the macro is able to monitor if "TEK 3" is selected at any time to act accordingly.

Many thanks for help

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[alice2011]

Thanks, John. It works perfectly. That is exactly what I want

[JOHN H. DAVIS]

You're welcome. Glad to help out, and thanks for the feedback.