+ Reply to Thread
Results 1 to 5 of 5

VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

  1. #1
    Registered User
    Join Date
    07-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    8

    Post VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

    Thank you but I should have been more specific. This code works for one table but I need this code to apply to the whole worksheet which has multiple tables - all tables have the same column layout and heading description. I have updated my sample attachment.

    I am looking for the updated VBA code that will work for multiple tables within one sheet.

    And thanks for incorporating the Approved Yes with date function into the code.



    I should have added to the post....looks like it deleted my original question. See Original scenario below.


    Scenario: I Have two columns with drop downs that each contain the selection "Disapproved". If column G is selected "Disapproved" I want column H same row to autoselect "Disapproved". I want it to work visa versa. If column H is selected "Disapproved" I want column G same row to auto select "Disapproved".

    With that said in the future should the selection need to change to "Yes-Approved" it seems I should just be able to highlight and delete/clear the cells and select another option in the dropdown.
    So I only need the "Disapproved" selections to be dependent on each other.

    As stated above when the Approved Column is selected "Yes" the current date is entered into corresponding row in Column J as shown in the files code.
    Attached Files Attached Files
    Last edited by b105; 07-04-2017 at 12:26 PM. Reason: Updating Sample File

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,392

    Re: VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

    Try change to
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    8

    Re: VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

    Need VBA Code to apply to whole worksheet which includes multiple tables- all tables have same layout and headings within worksheet

    Please see revised post and updated Sample attachment. Thanks guys!

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,392

    Re: VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    8

    Re: VBA Dropdown list selection Duplicate Specific selection on other Drop Down list

    Thank you! This works great!

+ 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 a dropdown selection format specific cells in a list?
    By neim0003 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-11-2016, 06:13 PM
  2. Creating a dynamic dropdown list of a selection of a master list
    By RooMar in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-15-2015, 05:27 AM
  3. Replies: 2
    Last Post: 12-10-2014, 12:42 AM
  4. Make same selection for multiple drop down list and clear all for all dropdown list
    By salomip13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2014, 01:34 PM
  5. [SOLVED] Remove pattern from cells only if another cell has a specific selection from dropdown list
    By mook25 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-16-2013, 07:32 AM
  6. Autolock Cells from a Drop Down List Selection and a Calendar Selection
    By John Anderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 10:54 AM
  7. Show specific rows and colums on dropdown list selection
    By info5 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 02:22 AM

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