I have a userform with a checkbox in it. The checkbox default value is set to true, but I would like it to only be true if the formula bar is visible. The code I have so far is:

Private Sub Frame1_Click()
If Application.DisplayFormulaBar = False Then
CheckBox1.Value = False
End If
End Sub

The code is placed in the frame section, but the checkbox only updates when the user left clicks anywhere inside frame 1. What I really need to do is force checkbox 1 to update as soon as the check is performed.

Thanks in advance for any help.