Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-08-2023, 05:46 PM
sbaidoo10 sbaidoo10 is offline How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu Windows 10 How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu Office 2019
Novice
How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu
 
Join Date: Apr 2023
Posts: 2
sbaidoo10 is on a distinguished road
Default 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.
Reply With Quote
 



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
How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft