Problems searching Excel cells for InStr text comparison, cant get cell values ...

I am trying to compare text/ InStr textcompare in Excel cells (z1, to z24) in sheet1, 2, 3. This will be compared to say, textbox1.

I want to search the z1,z24 cells for the textbox1 contents.






Here was what I came up with but it doesn't work:
'this is what I came up with, but the 'cellblock' variable is being set to the "text" not the actual cell contents...
'this sets the cellblock variable to "sheet1.range(z1).value" -- where as, it should actually be the "contents" of the cell, not the name of it....

Please Login or Register  to view this content.

My crude programming is not allowing it to work correctly. Is there a better way to do this ??


Thanks !

Hey Richard, that seemed to be the easiest fix but I couldn't get it to work... All it produced was NULL values for me. I do agree with you about the loop and ending, it was a quick example I usually use "loop1" or something, and I use loop1(s) and ending1(s) because I am not great with VB code, I have to take the crude approach...


MickG, I used your example and changed it to "InStr" instead of "=", and modified it to work with the entire book. I had to rework the way "true/false" was handled, but,


IT WORKS GREAT !!!
(Uhh ohh, I just realized the code is case sensitve... Isnt there a $case or something like that I could use to make it non-case-sensitive, or binary mode or something? I will start my own research but a quick reference would be helpful)
[NEVERMIND, resolved, I did it another way by just converting everything to UPPER case.... problem solved]


Thank you both for your input.



[RESOLVED]