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

Jo,

Try this...

once your user inputs a value in your textbox12 say the
input is "txt12" then simply insert the value captured
into a sheet much like what Chong was talking about.

e.g. worksheets("Sheet1").cells(1,1) = textbox12.value

this will save your value of "txt12" in sheet1 in cell A1.

Hope that helps,
-Neil

-----Original Message-----
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

.

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.

Declare txt12 like this: Public txt12 As String
in the regular module that opens and closes the UserForm.

HTH,
Merjet