troubleshooting Question

vba search form adjustment_02

Avatar of Frank .S
Frank .SFlag for Australia asked on
VBA
7 Comments1 Solution17 ViewsLast Modified:
hi experts, could you please make the following adjustment in the 'recipes' wksht of this wkbk.
- the search form result needs to only show the data if the search text appears only in column 'B'. For example the search text 'brick' is shown twice throughout the sht, once in column 'B'  & once in cell T13 which is from a different recipe name.
I need the text search to only search from col 'B', no other columns. If for example in the search of 'brick' there are other cells with 'brick' then these will need to be shown in the form result as red text & added to the "items found" list.
29216197a.xlsm
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros