Spoke too soon.
Iv added a bitton to hide the form, but I close the folder and open it again
it does'nt save the values. Still reverts to the value of 74?
--
Tdp


"Tdp" wrote:

Brilliant Jim.
So simple.......did'nt think of that.
Many thanks
--
Tdp


"Jim Thomlinson" wrote:

So why close the form. Just hide it...

userform1.hide
or
me.hide
--
HTH...

Jim Thomlinson


"Tdp" wrote:

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