Use Find to search user specified sheets in a workbook for a specific value in a specific column

chazrab

Well-known Member
Joined
Oct 21, 2006
Messages
917
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

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