modify code to add comment when cell in range have specific text or partial text

**mazan2010** · 11-21-2021, 08:01 PM

Good morning

im looking to make code that will add comment if any cell in range have specific text {IIN}
i already found the following code that can add comment if cell value is larger than column

the message i need to add to comment if IIN is {Please check data for}

my range of cell is A2:I125

Please Login or Register  to view this content.

**J.Green** · 11-21-2021, 10:11 PM

Please Login or Register  to view this content.

**bebo021999** · 11-22-2021, 05:14 AM

PHP Code:


Sub TEST() 
For Each Rng In Range("A2:I125") 
If InStr(1, Rng, "IIN") > 0 Then 
Rng.AddComment "Please check data for" 
End If 
Next 
End Sub

**mazan2010** · 11-26-2021, 02:40 PM

thank you so much for your support
work perfect

modify code to add comment when cell in range have specific text or partial text

LinkBack

Thread Tools

Rate This Thread

Display

modify code to add comment when cell in range have specific text or partial text

Re: modify code to add comment when cell in range have specific text or partial text

Re: modify code to add comment when cell in range have specific text or partial text

Re: modify code to add comment when cell in range have specific text or partial text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need help calculating Averages based on specific text & partial text

[SOLVED] Modify VBA code to paste report as text into specific columns in a Worksheet

[SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text

Find specific text in cell that matches range, then display specific text

if match partial text from a cell to a range copy row

How to modify the following code to copy comments containing specific text

please help Need VBA code that searches for partial text in a cell

Bookmarks

Bookmarks

Posting Permissions