VBA search on cell value with wildcard

**Cooky857** · 03-02-2021, 06:25 PM

Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell,

Code:

  searchvalue = reportsheet.Range (”C2”) .Value

this works fine if the content in “C2” is exactly right, but I’m using for ref numbers and they are long and complex is there a way to add a wild card or something so the vba will search for all matches, for example :

If C2 was 357, the vba would pick up 357, 2357, 3579, etc.

hope I’ve explained this enough if you want or need more let Me know

Thanks

**maniacb** · 03-02-2021, 06:30 PM

Try something like this

If reportsheet.[C2].value like *357* then
     Searchvalue = reportsheet.[C2].value 
End if

**Cooky857** · 03-02-2021, 07:00 PM

Hi, that would be great but there are nearly 300k of serial numbers that are 15 digest long containing letters and numbers and sorry the number I used was totally random, I need it to search for all any cell that contains a whatever is in C2.

Hope that makes sense.

**romperstomper** · 03-02-2021, 06:38 PM

How are you actually doing the search?

**Cooky857** · 03-02-2021, 07:08 PM

Sorry hard to explain, but I am searching what ever is in cell C2, on multiple sheets. If I put in the full serial number it works fine. It’s a modified version of this

https://www.youtube.com/watch?v=DOW3SjBjg6I

Just with a much larger data set

**romperstomper** · 03-02-2021, 07:16 PM

It would have been so much simpler to post the code or the workbook. You basically need to change this:

If (dataArray(i, searchField) = searchValue) Then

to something like:

If (CStr(dataArray(i, searchField)) Like "*" & searchValue & "*") Then

**romperstomper** · 03-02-2021, 07:17 PM

It would also have been nice if you'd mentioned that you have posted this in other forums too...

**Cooky857** · 03-02-2021, 07:34 PM

Hi Rorya apologies, I did not post the sheet it the code direct as it on my pc in the office and I’m on my tablet at home, as for using another forum if that is frowned apron again apologies. Just trying to get a response ASAP as it’s driving me crazy.

Thanks so much for you help it’s really appreciated.

I’ll give it a go tomorrow and let you know.

**Cooky857** · 03-03-2021, 04:08 PM

Hi your code seams to be working treat thanks very much

VBA search on cell value with wildcard

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Re: VBA search on cell value with wildcard

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Wildcard Search Range of Cells to Return That Cell Value

Checking cell contents for wildcard-suffixed values without hardcoding the search term

[SOLVED] Wildcard Search Criteria

[SOLVED] Search using wildcard

[SOLVED] Wildcard Search

[SOLVED] how to use a wildcard with an IF formula to search for text in a cell

If, And, wildcard search

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions