John.McLaughlin
Board Regular
- Joined
- Jul 19, 2011
- Messages
- 169
Hello!
My cell contains an Index Match, I want to test for the .Value of the Index Match, then insert a Check Mark. My statement keeps testing the formula.
The column is simple checklist populated by a product code. Almost every product has a different number of items to check off. I only want to insert the checkmark in the cells containing the 1st character "_", the underscore,
e.g.
____ Widget 1
____ Widget 2
Any ideas? Thanks in advance!
My cell contains an Index Match, I want to test for the .Value of the Index Match, then insert a Check Mark. My statement keeps testing the formula.
Code:
Range("A12").Select
If (Left(A12, 1) = "_") Then
ActiveSheet.Pictures.Insert( _
"C:\Images\Red-Checkmark.png").Select
Else
End If
The column is simple checklist populated by a product code. Almost every product has a different number of items to check off. I only want to insert the checkmark in the cells containing the 1st character "_", the underscore,
e.g.
____ Widget 1
____ Widget 2
Any ideas? Thanks in advance!