+ Reply to Thread
Results 1 to 6 of 6

Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

  1. #1
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    After constant searching the forum, I've encountered different ways where the sheet tab name changes automatically using Macro depending on a certain cell value.

    However, it doesn't seem to work (maybe because the cell value) changes between the categories under the listed data validation dropdown. I'm really not sure though...

    Could anyone help me here?


    ECR1.xlsm

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    Your code is checking to see if cell A6 changed:

    Please Login or Register  to view this content.
    but A6 is in a hidden column and looks like it never changes. Cell H8 has a data validation dropdown--is that the one you really want to use? Change to

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Re: Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    Quote Originally Posted by 6StringJazzer View Post
    Your code is checking to see if cell A6 changed:

    Please Login or Register  to view this content.
    but A6 is in a hidden column and looks like it never changes. Cell H8 has a data validation dropdown--is that the one you really want to use? Change to

    Please Login or Register  to view this content.
    I already tried that sir, but it didn't change as well...

  4. #4
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Re: Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    and also, cell A6 is actually referencing back to cell H8, so if H8 changes, the cell A6 also changes its value..
    I just did that because I thought the macro does not recognized a dropdown list.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    The Worksheet_Change event will not recognize that A6 has changed, because its formula has not changed. Worksheet_Change only recognizes if the content of a cell changes, not if a calculated value changes. The macro definitely does recognize a dropdown list, because it is still a cell value. I made the change in your file before I posted the suggestion, and it worked for me. Please see attached.
    Attached Files Attached Files

  6. #6
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Re: Sheet tab Renaming from Cell Value (cell using Data Validation Dropdown)

    NOW that works it all out!

    Thanks Sir!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can't see in-cell dropdown using data validation
    By maacmaac in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2019, 12:38 PM
  2. [SOLVED] Data validation dropdown list in cell IF...
    By jayherring86 in forum Excel General
    Replies: 6
    Last Post: 01-20-2015, 12:00 PM
  3. Data validation dropdown with in cell-dropdown?
    By OldManExcellor in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 08:14 AM
  4. Urgent: Dropdown Cell Validation Data is shown next to each other
    By Klaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 05:52 PM
  5. Replies: 2
    Last Post: 09-26-2009, 08:18 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