Results 1 to 4 of 4

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

Threaded View

alice2011 Select a specific value from... 03-14-2014, 01:32 PM
JOHN H. DAVIS Re: Select a specific value... 03-14-2014, 01:38 PM
alice2011 Re: Select a specific value... 03-14-2014, 01:50 PM
JOHN H. DAVIS Re: Select a specific value... 03-14-2014, 01:52 PM
  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

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

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Select Picture via Dropdown list
    By cmlucifer in forum Excel General
    Replies: 6
    Last Post: 01-21-2014, 02:51 PM
  2. Replies: 4
    Last Post: 09-10-2013, 02:11 PM
  3. Replies: 9
    Last Post: 05-22-2011, 09:26 AM
  4. How to select different Macros from a dropdown list?
    By globulous in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2007, 12:16 AM
  5. select multiple items from a dropdown list
    By Rebecca1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-17-2006, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1