thanks
I think my problem was using .value instead of .text
Jo

-----Original Message-----
See my reply to your earlier post. I forgot to add that,
of course, you need something like what follows in the
Userform's code module.

Private Sub TextBox1_Change()
txt12 = Userform1.TextBox1.Text
End Sub

HTH,
Merjet


.