Hi gurus,

I was wondering if someone might be able to help me with this vba below. I've got a bunch of radio buttons that I only want "enabled" if a specific word (USD-BONY in this case) is in a range in column C, otherwise they should be disabled.
I thought what I've got below would have done the trick, but it's not updating the Radio button based on the table information, only when I change the first USD.Enable =, between TRUE/FALSE.

Hope the explanation is clear enough, yell if you need more info.

Note: USD is the name of my radio button 

Private Sub USD_enable()

Dim c As Range
Dim ccY As String

ccY = "USD-BONY"

For Each c In Sheets("Sheet1").Range("C14:C81")
    If c.Value = ccY Then
        USD.Enabled = True
        Else
        USD.Enabled = False
    End If
Next c

End Sub
Many thanks,
OM.