Check Manually Inputted Text in Cell Range Contains Text from Several Validation Dropdown Lists

bearwires

Board Regular
Joined
Mar 25, 2008
Messages
57
Office Version
  1. 365
Platform
  1. Windows
I have manual inputted text strings in cell ranges:

B104:B125
B132:B175

There are validation dropdown Lists located in the following ranges:

B200:B212
D200:D212

B221:B231
D221:D231

The drop down lists could be 1 text string in 1 cell or 1 text string in every cell in the specified ranges.

I would like to check that the manually inputted text that is typed into cells B104:B125 & B132:B175 contains all the text strings selected from the validation dropdown lists.

If it does contain all items in the dropdown lists, then continue with rest of the VBA code I have to hide cells.

If it doesn't contain all items in the dropdown lists, popup a message showing a list of items from the dropdown list not included in the manually inputted text and prompt user to rectify.

Is this possible and can anyone help me out to make it happen?

Thanks
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,224,814
Messages
6,181,126
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top