Dear All
I have an excel file where i have a text box with VBA code to filter the search.
This excel has 4 column B.C.D.E.F
I have 2 Concerns
first the text box searches in column B only, i want to change code to search in complete sheet
for example if i search S 400 which is in column E then search is not working.
Second thing after first concern is solved , if the column D is filtered with 'SALES' then the text box filter ignores/Clears the column D filter
But i want search result after the filter in column D . For example if i filter column D 'SALES' then the search within this filter is not working.
Thank You
I have an excel file where i have a text box with VBA code to filter the search.
This excel has 4 column B.C.D.E.F
I have 2 Concerns
first the text box searches in column B only, i want to change code to search in complete sheet
for example if i search S 400 which is in column E then search is not working.
Second thing after first concern is solved , if the column D is filtered with 'SALES' then the text box filter ignores/Clears the column D filter
But i want search result after the filter in column D . For example if i filter column D 'SALES' then the search within this filter is not working.
Thank You