Highlight Characters in String Using VBA

[@mrzer0830]

Very Clear , Thanks a lot. you are a really master. Grettings from Buenos Aires

[@mrzer0830]

Hello, I found this video interesting, I tried to do the same with numbers (cells with general format, not text) without success. Do you know if there is any way to highlight a specific number in a cell, for example 6 in the number 3064. NOTE: WITHOUT changing the cell format. Thank you Greetings from Buenos Aires, Argentina

[@anupamthaparak]

Hello Sir, i am very new to VBA. Could you let me know what has to be modified in the code if we want to compare text in two cells and highlighting/colouring only the ones which are different. Eg if cell 1 has ‘abcd’ and cell 2 has ‘abed’ it should highlight ‘c’ in cell 1 and ‘e’ in cell 2 as that particular part of the string is different

[@ryuchan2578]

Up

[@prakashgathibandhe6140]

Thanks Sir, to upload this vedio and i found how to create next code as per my previous question.

[@massimolorenzi6640]

compliments very clear and direct

[@Exceltrainingvideos]

Thanks. Please share with your friends and colleagues.

[@warmvision1990]

Thank Sir I enjoyed this video and I found it useful 👍🏻

[@krn14242]

Thanks Dinesh. What's the offset for?

[@Exceltrainingvideos]

Didn't you notice the selection of cell C7?

[@kunalrathore261]

Hlwo, I have a question, in this you tell me that highlight a curly brackets in a cell but I want to highlight a fourth or fifth character in a cell how we do tell me as soon as possible

[@Exceltrainingvideos]

Change this line of code according to your needs: If Cell.Characters(Counter, 1).Text = “{” Then This link will help. Let me know if this solved your problem.

[@vyshalkumar8327]

Hi Sir, Thanks in advance I want to highlight the specific text in "G1" cell text which is not available in the SAME ROW.("Z1" to "AN1") For example : cell "G1" contains "hello sir i am doing well" but the word "sir" is not available in SAME ROW (ranges "Z1" to "AN1") so the text "Sir" should be highlighted Note : i want to loop this code for all the cells in "G" column likewise the ROW should also change from row 1 to ...........

[@mohammadnaim3345]

thanks sir... but i got error 1004 unable to get the text property of the characters class... how to fix this

[@mohammadnaim3345]

how to apply this macro for a number?

[@DavidRajkumarGuitar]

Hai sir, u have shown how to highlight circular brackets, but I want to know how to hightlight all characters containing flower braces, square braces etc

[@Exceltrainingvideos]

Why don't you try that out?

[@touseef220]

Hello sir, I have a problem in excel as I want to create a template for my work. I need your help. Can I ask you for email so that I send you details Regards

[@Exceltrainingvideos]

Do a search at www.exceltrainingvideos.com

[@bricc322]

Very interesting! Thank you.

[@akshays20469]

nice sir. but I would like to know that can we input data in hindi through textbox

[@Exceltrainingvideos]

Select the text box. In the font properties change the font to some Hindi font like 'Kruti Dev 010'.

[@akshays20469]

Dinesh Kumar Takyar thank you sir, but it won't show data in hindi in worksheet .

[@Exceltrainingvideos]

LOL. Of course you should use a Hindi keyboard and have Hindi as your language installed via the control panel.

[@levimoore800]

what if instead of characters I want to do words?

[@Exceltrainingvideos]

Try it out!

[@haribabu-nl5rg]

conditional formatting colour is not recognised by macro,how can get background colour number of conditional formatting cell not normal background cell sir

[@Exceltrainingvideos]

www.exceltrainingvideos.com/highlight-characters-in-string-with-vba/

[@SheittaHerr]

I'm interested keep me posted

[@nammarcr33737]

How to count characters in userform From Textbox1 and result in Textbox 2

[@Exceltrainingvideos]

Use the LEN function for TextBox1 and the assign the value to TextBox2.

[@nammarcr33737]

@@Exceltrainingvideos Thank you

[@eliasaouad13]

I was practicing with the tutorial & followed each step exactly as you described and received error: Tun-time error '424' Object required. I reviewed the steps and they match exactly. Not sure where the error is. Hope you can help and explain. Thank you. Sub HighlightCellCharacters() Range("C1").Select Dim rng As Range Set rng = Range("C1:C6") For Each cell In rng Dim counter As Integer For counter = 1 To Len(cell) If cell.Characters(counter, 1).Text = "{" Then cell.Characters(counter, 1).Font.ColorIndex = 3 End If Next AtiveCell.Offset(1, 0).Select (This is where the error occurred) Next cell End Sub

[@Exceltrainingvideos]

AtiveCell.Offset(1, 0).Select ---> ActiveCell.Offset(1, 0).Select

[@eliasaouad13]

Thank you

[@mohdrayees7297]

In one sheet how to match two value by using vba

[@Exceltrainingvideos]

Run a looping process.

[@govindkumarsodani3290]

Usefull

[@rakeshmewada9823]

NICE SIR

[@Siva-DigitalEnglishEducation]

good