user Forms Question

[sharonm]

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!

 

[Jim Cone]

Worksheets("Sludge").Range("A1").Value = Me.Textbox1.Value
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"sharonm" <
wrote in message
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!

 

[john]

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