Mark,
Ron de Bruin has many examples of sending email from VBA at his site at
www.rondebruin.nl/sendmail.htm, including sending a worksheet range which is
another example of text, if that is where your question is directed.
If your question is how to get the text from the userform, that is easily
achieved with
myVar = Userform1.Textbox1.Text
which loads the text into a variable, where you should be able to load into
an email, or
Range("A1").Value = Userform1.Textbox1.Text
loads the text into a worksheet range, where Ron's tips kick in.
The userform must be in memory, even if it is not showing, when you get the
text, otherwise it is gone.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
