Ok...getting a little bit frustrated with this, mainly because i thought i knew what i was doing!!!

I have the code below...

If CheckBox1.Value = True Then Range("B2").Value = "Yes"
End If
But it keeps coming back with an End If without block if but I dont understand why?!?!

Please help!