VBA code to populate checkbox with tick upon initialization based on Cell value being Yes

Hi

I am trying to populate checkboxes if there is data in a specific cell for example if Cell D2 =Yes I would like a tick to appear in Checkbox1. I am using Userform 2 and my sheet is called "Validation" I am hoping the ticks will show when the userform initializes.

I have more checkboxes all relating to specific cells but am hoping if someone can start me of I will be able to do the rest.

Thanking you in anticipation for your help

Try this:-

Please Login or Register  to view this content.

Regrds Mick

Hi Mick, Thanks for your reply just added your code and its exactly what I needed. Thanks for your help.

Michelle

You're welcome
Regrds Mick