Why not use the Checkbox Click event (activex control) for the call to Mail based on the checkbox value? The code depends on whether you used a forms control or an activex control.

I see no reason for the [B7].value to not work. Most likely, the value is "". Of course the B7 is for the activesheet as is Range("B7").Value.