Worksheets("sheetname").Range("A1").Value = TextBox1.Text

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bennyob" wrote in message
...
What is the simplest code for delivering numerical data from a text box to
a
specific location (no loops etc to find empty cells) in specific
worksheets?
I want several data entries from the same form to go to different
worksheets.
Any help will be greatly appreciated
Cheers Ben