Have a look at Ron de Bruin's site copying to a database sheet.
you should be able to adapt this to work with your form.
http://www.rondebruin.nl/copy1.htm
--
JB


"sharonm" wrote:

Hello,

is it possible to have a user enter data through a User Form which I have
created and then update a flat Excel worksheet (located either in the same
Workbook or a different one) with the data entered onto the User Form?

I have been trying to find some examples of how this would be done with no
luck. Does anyone know of any good sites or places I could take a look at?

Thanks!