Search through Cells Containing String using VBA Excel Programming

This video shows how to Search through Cells and count the cells Containing certain String using VBA Excel Programming. This will count the number of occurrences. To see code, look at my response to the video.

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

[mubasharhill]

Thanks Alex C. Your code helped me a modified way to accomplish my target code... Please keep up good teachings.

[thebosdthews]

Somany people overlook simple methods like this! thanks for your guidance!

[sktneer]

You are a good teacher. Thanks for the tutorial.

[djohnson]

Thanks that was helpful. I will be watching more of your videos

[gloriabukachi]

thank you very much, very easy to understand, it work!

[akontiki]

Hi dear alex
, first of all i would like to thank you. Your code working with great
satisfaction. But i got a question, is there any way to alter the code
so it can find multiple data? and show next find? for example in Colum
"A" we have 2 names that qualify for the search. I need to find the next
one. but with each start of the command it starts from Row 0, and
cannot never show the secound or the third match?. any idea?? i would be
very greatful

[mathieulapointe]

thank you its a great time saver for me

[sammybenmenahem]

Cool . Question - How can a search a certain text string within a specific Cell ?

[Mh-oo]

Great video, can you tell me how to loop through a column of concatenated hyperlinks that open .dwg files and print them

Thanks in advance

[erwindgaming]

can u help me. i want to copy cell contain string like as your video. but i want to copy that cell to sheet2. because i want to create resume data... please make this video... thank you

[mrabalone]

thanks for your sharing Alex,
i have an issue, what if i want to search for let's say column A to column C
i would code in : searchstring = Range(Cells(1, 1), Cells(row_number, 3)).
sadly it doesn't work this way. Has anyone encounter this issue?

[gtaiwo]

How would you copy the found string to the adjacent cells in VBA?

[rohailahmad]

hi sir, how to check weather one cell contain circle, triangle or rectangle shape in it

[casst]

ok..what if you have a text column with text string of 20 numbers in each row that are random from 1-80...(the format for the text string looks like this, they differ all the way down the column but the format is the same and the total of 20 numbers in the same...now, how do you look thru this column to pick up anywhere the numbers 02-26-76 appear in any of the rows in the column of numbers regardless of the order...not in side by side string order..you can see above there is a match, or that 20 numbers do contain 02-26-76...what formula can i put in that will say yes or match, or anything to indicate a hit on that it contains those 3 numbers?

[satpalbhullar]

nice one. can u also ell how to get the cell value for all the occurrence of that string to that based on cell value calculations can be done

[vishalkakani]

i have entires of 1000 plus names to search and extract from a table of 500.
suppose i got table A with entries " BOOK, AXE, TABLE, SCREEN, INTRO, PEN, BALL"
and i want to extract specific words like "book and axe" like 1000 words from table A and put it into another table. how to do it.?

[gabrieldionisierotar]

Hello, Thank you for the video, but I have a special situation, so if you read this and you can help me, then please respond me right here. What I want to do, is to search in text if i have a comma between 2 letters, any kind of, like "r, g", "d, f" and so on... But not between 2 numbers, like "2, 5"

[nikkisalangad]

i need it for my project thank you in advance

[cedrust]

How do i select the first in column A which contains the string instead of just knowing the cell address?
If InStr(the_ticker, theunderlying) > 0 Then
'Cells.selection
Need your expertise in this area. Thanks in advance
Cheers!

[nikkisalangad]

Sir I have problem in excel VBA, I want to do a program that will search for specific header of column and its row content, then automatically add new column containing tags of the column i search, example When i click the button, it automatically search for "date column" then add week column then put values in there. like 1/13, 2013, 1/15/2013, 1/17/2013 in "date column" then tag them as week 1, week 2 so on in "Week number column". can you do a tutorial for this? this will be vry helpful tnx