Results 1 to 6 of 6

Sheet Change when Value is Selected

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2023
    Location
    USA
    MS-Off Ver
    2008
    Posts
    7

    Sheet Change when Value is Selected

    Hello,

    I have a data validation list / drop down menu of dates in mmmm d format. I am trying to code the workbook so that when a date is selected, you are taken to the sheet with the matching date name. For example, if I select June 29, I want to automatically be taken to the sheet labeled June 29.

    This is the code I currently have:
    Private Sub Worksheet_Change(ByVal Target As Range)
        On Error Resume Next
        If Not (Application.Intersect(Range("B1"), Target) Is Nothing) Then _
            This Workbook.Sheets(Target.Value).Activate
    End Sub
    B1 is the drop down list selection. When I debug, the first line errors. What am I doing wrong?

    DEMO.xlsm
    Last edited by goldyf_ishy; 07-11-2023 at 12:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change formula to refer to selected sheet
    By josephteh in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2023, 10:53 PM
  2. [SOLVED] Balance change over selected periods at a selected % rate
    By vill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2017, 04:58 PM
  3. Change Selected Cell Colour ...only whilst selected
    By mrgrotey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2017, 07:40 AM
  4. Replies: 4
    Last Post: 09-16-2013, 04:23 PM
  5. [SOLVED] Trying to copy selected items from sheet to listbox then selected back to sheet
    By BigWes1960 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-14-2013, 03:27 PM
  6. Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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