Request for help with VBA Like Function

[dhunton]

I have written a bunch of VBA that works just fine. But the Like function is just messing with my mind. This is the relevant portion of my subroutine:

Please Login or Register  to view this content.

I have used Debug.Print to check that TempArray(0) and TempArray(1) are pulling "Hello " and " Goodbye" respectively, so I really don't know what I'm doing wrong.

The only thing that I'm not including in the above is that the SourceString is actually ThisWorkbook.Worksheets(1).Cells(1, 1).Value only with different numbers. I do a Debug.Print of that Value before I test to make sure I'm looking at the right information.

[Winon]

Hello dhunton,

Welcome to the forum.

...This is the relevant portion of my subroutine:

And that would be a problem for most of our esteemed Forum Members.

Could you please provide us with more info, or better yet, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[AlphaFrog]

I get Found equals True. What's the issue? What do you want it to do?

[dhunton]

I get Found equals True. What's the issue? What do you want it to do?

I never get that. Running line by line, it jumps right from the If line to the End If line without running the Found = True line.

[AlphaFrog]

I never get that. Running line by line, it jumps right from the If line to the End If line without running the Found = True line.

I tested using your copied code with no changes. Are you using your TestString in code above or a cell value?

[dhunton]

You're right. Mine had some additional text in the SourceString before the first word in the TestString. If you make the following change, you won't get a True result, either. And I need it to return True for something like this.

SourceString = "I said Hello then said Goodbye to her"

[dhunton]

Dang... problem is it's case sensitive... I was lazy on my own test and didn't capitalize.

Is there any way to make "like" be NOT case sensitive?

[jindon]

Is there any way to make "like" be NOT case sensitive?

Try add one line on the top of the module (out side any procedure)

Please Login or Register  to view this content.

[AlphaFrog]

Dang... problem is it's case sensitive... I was lazy on my own test and didn't capitalize.

Is there any way to make "like" be NOT case sensitive?

Please Login or Register  to view this content.

[dhunton]

Try add one line on the top of the module (out side any procedure)

Please Login or Register  to view this content.

Would this affect any numeric comparisons? When I glanced at it, it seemed like it would, so I didn't look further.

[dhunton]

Please Login or Register  to view this content.

That works perfectly for what I need! Thank you!