|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu
If range A2:C26 contains data, and column A (Batch ID) has hyphenated data with a two-digit code to the left of the hyphen and a 4-digit code to the right of the hyphen in column A.
The first letter of the Batch ID is known as the Identifier and the leading number of the 4-digit code to the right of the hyphen is known as the Key. For example, in the Batch ID "N9-363B", the Identifier is "N" and the Key is 3: How do I create a subroutine that allows me 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 to be highlighted GREEN. |
#2
|
||||
|
||||
Please, help us to help you, attach a workbook with this in.
|
#3
|
|||
|
|||
Sample Data set
Dear p45cal,
Thanks for your willingness to help. Please, find the attached workbook for your further action. |
#4
|
||||
|
||||
Have you posted the right workbook? It doesn't seem to relate at all to your query:
2023-04-22_112511.png |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
create a subroutine that allows the user to select the Identifier from a drop-down menu | Isi | Word VBA | 5 | 01-16-2023 05:23 PM |
Cascading drop-downs in Word with one parent menu and four dependent drop-downs | mrstrawhand | Word VBA | 3 | 03-30-2020 06:08 AM |
Auto create new worksheet when select option from drop down list | JANET JONG | Excel Programming | 1 | 08-01-2018 07:13 AM |
Create a command button that will insert another drop down menu | Tinamation | Word VBA | 1 | 11-06-2015 03:11 PM |
Help, auto select drop down by another drop down value? | skrallemand | Word VBA | 3 | 09-11-2013 11:55 AM |