Enable/Disable Radio Button based on table data

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

Please Login or Register  to view this content.

Many thanks,
OM.