I am hiding the form rather than unloading it so it should
be there somewhere.........

Is there a way to do this without transfering the values
to the worksheet? Such as declaring my result for
textbox12?
Thanks
Jo

Hi
I am still having problems getting the data from textbox
entries into other modules.
I would like to be able to name userform1.textbox12.value
as txt12 and then have it available to all other macros.
May be I am putting the code in the wrong place?
Thanks agian for all your help.
Jo

...


..

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

myval = Userform1.Textbox12.Text

--
Regards,
Tom Ogilvy

"Jo" wrote in message
...
I am hiding the form rather than unloading it so it should
be there somewhere.........

Is there a way to do this without transfering the values
to the worksheet? Such as declaring my result for
textbox12?
Thanks
Jo

Hi
I am still having problems getting the data from textbox
entries into other modules.
I would like to be able to name userform1.textbox12.value
as txt12 and then have it available to all other macros.
May be I am putting the code in the wrong place?
Thanks agian for all your help.
Jo

..


.

thanks
I think my problem was using .value instead of .text
Jo
-----Original Message-----
myval = Userform1.Textbox12.Text

--
Regards,
Tom Ogilvy

"Jo" wrote in
message
...
I am hiding the form rather than unloading it so it
should
be there somewhere.........

Is there a way to do this without transfering the values
to the worksheet? Such as declaring my result for
textbox12?
Thanks
Jo

Hi
I am still having problems getting the data from textbox
entries into other modules.
I would like to be able to name
userform1.textbox12.value
as txt12 and then have it available to all other macros.
May be I am putting the code in the wrong place?
Thanks agian for all your help.
Jo

..


.




.

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


.