I would like for code to just accomplish these 4 things with a vba code block:
1) Specify which sheets to search using Find 'from a combobox selecting specific sheets and then copying each name to a listbox on the form
2) Specify which column in each selected sheet to search 'the same column in all sheets - say G
3) Find all values of string value x in part of the string (xlPart) in all cells in col. G
4) Copy each result to a new sheet named RESULT and display the RESULT in a new userform
‘Search only these Sheets in Workbook that contains Sheet1 through Sheet20 sayL
Sheet1
Sheet3
Shet6
Sheet7
To find x string value ‘any string value or part of a string(xlPart) in all cells that contain x In column G ‘could be any column ‘giving the user a choice from cols A thru K
Copies rows A thru L of all results to a new sheet
This seems like it has been done many times via yt ids, etc.
However none I can find gives a userform with combobox, listbox and/or textbox
choices from which to enter input values from.
Any help on this would be greatly appreciated.
Thanks, cr
1) Specify which sheets to search using Find 'from a combobox selecting specific sheets and then copying each name to a listbox on the form
2) Specify which column in each selected sheet to search 'the same column in all sheets - say G
3) Find all values of string value x in part of the string (xlPart) in all cells in col. G
4) Copy each result to a new sheet named RESULT and display the RESULT in a new userform
‘Search only these Sheets in Workbook that contains Sheet1 through Sheet20 sayL
Sheet1
Sheet3
Shet6
Sheet7
To find x string value ‘any string value or part of a string(xlPart) in all cells that contain x In column G ‘could be any column ‘giving the user a choice from cols A thru K
Copies rows A thru L of all results to a new sheet
This seems like it has been done many times via yt ids, etc.
However none I can find gives a userform with combobox, listbox and/or textbox
choices from which to enter input values from.
Any help on this would be greatly appreciated.
Thanks, cr