Find partial text in cell and assign variable a value if found

**lday75** · 07-26-2012, 01:08 PM

I am trying to search for specific words in a cell, and if found, I want a variable assigned a value "1", if not found then that variable gets a 0. My code is listed below. This runs without error, HOWEVER it does not change my values for the variables, in the msgbox at the end it still shows all 0's even though the text I am searching for is present in the cells.

if I STEP through the code in VBA it is ignoring the ELSE for each of the IF THEN statements?

thoughts?

Please Login or Register  to view this content.

**tigeravatar** · 07-26-2012, 01:22 PM

lday75,

Instead of using worksheetfunctions to get see if there is a string within a string, try using the VBA method InStr:

Please Login or Register  to view this content.

**lday75** · 07-26-2012, 01:27 PM

tigeravatar - This is producing the same results. Sorry, but thank you for the quick reply.

**tigeravatar** · 07-26-2012, 01:29 PM

lday75,

Works just fine for me when I tested it. Can you provide an example workbook that explains what results you're looking for?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
To attach a file, click the "Go Advanced" button and then click the paperclip icon to open the Manage Attachments dialog.

**lday75** · 07-26-2012, 01:36 PM

I was able to get this resolved by using a COUNTIF statement and this is producing exactly what I was looking for. Code below

Please Login or Register  to view this content.

In a nut shell, what I need is for this code to recognize what vendors are listed on the Prod Rec sheet, and based off of the values of the Flg variables load one of 5 different userforms it gets rather complex after this section :>)

Thanks again for your help though, I appreciate the replies.