You can use the control source to link the textboxes to specific cells, or
you can run code that loops through the textboxes and writes the value found
in the textbox or you can have an event for each textbox (possibly Exit)
that writes the value of that textbox to the worksheet.
--
Regards,
Tom Ogilvy


"MDL2004" wrote in message
...
I've designed a user form with a multipage on it and managed to to get it
to
calculate totals thanks to Tom Ogilvy's advice recently but what i'm
trying
to do now is put the users text box values in particular cell on the
spreadsheet.
I thought i have worked it out but i can't remember where i read an
example
so i've just got a permanent mental block

If anyone can help it'd be most appreciated
Also is there any good websites that are good for beginners of VB ??