Force mandatory input into cell before closing

[LBryant777]

I am working on a workbook and I want to use an checkbox control to be checked off on each sheet if the form is completed. However, there is one cell on each sheet that needs to be filled in with text before the sheet can be considered complete. I tried using this code attached to an ActiveX control checkbox:

Private Sub cbCompleted()
If Application.Trim(f15) = "" Then
MsgBox "Complete the Comments Field."
Worksheets("Sheet1").Range("b10").Value = False
End If
End Sub

Regardless of whether the field has text or is empty, I still get the text box. Can someone help me? Thanks!

 

[SkipVought]

Please post code question in VBA Visual Basic for Applications (Microsoft) forum707

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[LBryant777]

I thought that forum might be more applicable after I posted here. Thanks for the confirmation!!