Avatar of Frank .S
Frank .S
Flag for Australia

asked on 

vba search form adjustment_02

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.

Avatar of undefined
Last Comment
Frank .S

8/22/2022 - Mon