If range contains "x", Then show/hide image VBA

[suptechguy]

Hello,

I'm looking for a way to have a VBA macro to look at a range of cells, determine if the value 'x' appears in the row; if Yes then hide image, if no then show image.

So the macro will be on sheet ("Upload Data") - commandbutton1
If worksheets("Prepared File").range("9:9") contains an "x", then hide image ("Smile")
If there is no "x" in the range, then show image ("Smile")

Could someone please help me?

Thank you!

 

[Caleeco]

Hello,

How about something like this?

Sub Toggle_Smile_Image()
    Dim ws As Worksheet
    
    Set ws = Sheets("Upload Data")
    
    If Application.WorksheetFunction.CountIf(Range("9:9"), "x") Then
        ws.Shapes("Smile").Visible = False
    Else
        ws.Shapes("Smile").Visible = True
    End If
End Sub

Let me know if it works
Cheers
Caleeco

 

[suptechguy]

Thank you! I had to slightly adjust it but it worked!

 

[Caleeco]

Awesome, thanks for letting me know! :D

 

[ArturBe]

Hello, i have a similar problem in VBA.
I hope someone can help me.
I want to hide all rows which have a certain value in column "C". But this value is dependent on two other values.
If column "B" contains the value "ABC" and column "U" > 100 then hide this row and hide all other rows that have the same value in cell "C"

Is anyone able to solve this problem?
Thank you very very much!!