+ Reply to Thread
Results 1 to 2 of 2

Create a subroutine that allows the user to select the Identifier from a drop-down menu

  1. #1
    Registered User
    Join Date
    01-02-2023
    Location
    Nigeria
    MS-Off Ver
    2010
    Posts
    4

    Create a subroutine that allows the user to select the Identifier from a drop-down menu

    Please how do I create a subroutine that allows the user to select the Identifier from a drop-down menu in cell F2 and the Key from a drop-down menu in cell F3 and any rows of the data (columns A, B, and C) whose Batch ID meets those criteria will be highlighted GREEN.

    T3-238L 10/12/2017 10/19/2017
    J9-488N 1/22/2018 1/29/2018
    H3-107R 1/27/2018 2/5/2018
    E6-104Q 2/13/2018 2/21/2018
    C1-465A 3/1/2018 3/6/2018
    N0-274O 4/27/2018 4/30/2018
    A8-43I 5/17/2018 5/24/2018
    C7-34N 6/9/2018 6/18/2018
    T6-287Z 7/30/2018 8/1/2018
    H2-479T 8/25/2018 9/1/2018
    H4-17P 9/7/2018 9/11/2018
    T4-491R 9/15/2018 9/21/2018
    E8-240R 9/29/2018 10/7/2018
    C3-24Z 11/27/2018 12/3/2018
    N9-363B 12/16/2018 12/23/2018
    T9-117W 2/24/2019 3/3/2019
    C9-286N 4/6/2019 4/12/2019
    H0-312Z 4/13/2019 4/18/2019
    A8-302T 5/22/2019 5/28/2019
    A6-329B 7/31/2019 8/5/2019
    E6-185C 8/6/2019 8/13/2019
    E6-359C 8/9/2019 8/16/2019
    H0-410R 8/31/2019 9/10/2019
    C0-283A 10/31/2019 11/4/2019
    Last edited by adokhai; 01-14-2023 at 10:11 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Create a subroutine that allows the user to select the Identifier from a drop-down men

    Please read the yellow banner at the top of this page on how to attach a sample workbook.

+ 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. VBA to select drop down menu
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2019, 02:01 AM
  2. [SOLVED] Create drop down menu to select file extension
    By fabian_76 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-13-2018, 11:37 AM
  3. Replies: 8
    Last Post: 08-11-2016, 11:07 AM
  4. Drop down menu in User form
    By winmaxservices in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 03:22 AM
  5. Select from a drop down menu using VBA
    By Johnnyv015 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2014, 02:55 PM
  6. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  7. select multiple items from drop-down menu
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 05-25-2008, 11:50 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