+ Reply to Thread
Results 1 to 4 of 4

Click Item in DropDown List To Auto Focus on Another Sheet?

  1. 12-12-2015, 01:53 PM #1
    Craigside
    Craigside is offline
    Registered User
    Join Date
    08-11-2009
    Location
    Lancashire England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Click Item in DropDown List To Auto Focus on Another Sheet?

    Hi

    I have a dropdown list containing certain sheet names from within current workbook. I want to be able to click an item in the dropdown list (ie a sheetname) and that worksheet be focussed.

    Can this be done in 1 click?

    Please see attched sample.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-12-2015, 02:02 PM #2
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Click Item in DropDown List To Auto Focus on Another Sheet?

    Right click on the sheet tab for the "Details" sheet and select view code.
    Paste this code into the window that pops up.
    Make sure your workbook is saved as a .xlsm macro enabled type workbook.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
    Reply With QuoteRegister To Reply
  3. 12-12-2015, 02:04 PM #3
    excel_bat
    excel_bat is offline
    Registered User
    Join Date
    11-18-2015
    Location
    Madrid
    MS-Off Ver
    2016
    Posts
    95

    Re: Click Item in DropDown List To Auto Focus on Another Sheet?

    Hi, this event code (written in Sheet1) should work:
    Please Login or Register  to view this content.
    excelbat.com: free Excel tools, macros...
    Reply With QuoteRegister To Reply
  4. 12-12-2015, 02:37 PM #4
    Craigside
    Craigside is offline
    Registered User
    Join Date
    08-11-2009
    Location
    Lancashire England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Click Item in DropDown List To Auto Focus on Another Sheet?

    Thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to auto fill a cell on new sheet when selecting item from drop down list?
    By kinny.mat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-16-2015, 12:27 PM
  2. Click on a hyperlink to another sheet and auto filter from dropdown list
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 02:34 AM
  3. How do I set worksheet to auto input number when item selected from dropdown list.
    By computerjen in forum Excel General
    Replies: 2
    Last Post: 12-06-2012, 05:52 PM
  4. Option button click ... then focus back to sheet ?
    By dannac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 02:05 AM
  5. [SOLVED] Auto copy/ paste on relevant work sheet when selecting list item
    By Niraj Manglam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2006, 10:15 AM
  6. TAB and focus moving from unprotected cell in protected sheet til dropdown.
    By Claus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2005, 07:05 AM
  7. [SOLVED] How can I set up to chose more than 1 item from a dropdown list (.
    By microchick in forum Excel General
    Replies: 4
    Last Post: 04-07-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1