exporting data from a form to a spread sheet

[R.H.]

I was wondering if someone could tell me how to export data entered on a
user form to a excel spread sheet.

Roger

 

[Nigel]

Not an export but an assignment process typically as follows.......

Range("A1").Value = UserForm1.TextBox1.value

Cheers
Nigel

 

[R.H.]

Thanks, that worked.

Not an export but an assignment process typically as follows.......

Range("A1").Value = UserForm1.TextBox1.value

Cheers
Nigel

 

[trey braid]

ive been told i need to have schema's to do this... im trying to set it up where when a form is filled out for a client the info automatically populate's an excel spreadsheet...