ActiveX Control deleting information after printing

C

Colleen Chisnell

I have created a form using the form wizard. When the activex checkboxes are clicked on, they show that way on the screen, but as soon as the form is printed, the checkboxes all click to off. Can someone help me?
 
D

Dave Peterson

I guess my first question is:

Is this a display problem or do the values really change?

Maybe you can look at the linked cell or even a little macro:

Option Explicit
Sub testme()

With Worksheets("sheet1").CheckBox1
If IsNull(.Value) Then
MsgBox "Null"
Else
MsgBox .Value
End If
End With

End Sub
 
Top