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

..