View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tdp Tdp is offline
external usenet poster
 
Posts: 74
Default CheckBox does not save value

I have the following code
Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Me.TextBox10.Value = Worksheets("Sheet4").Range("E9")
Else
Me.TextBox10.Value = 0
End If
End Sub

The problem I am having is that when I close the UserForm, the values in the
textbox do not save. It seems to default to random number, in this case 74!!??

Can any one hepl?
--
Tdp