How to export data from forms to worksheets?

[episode80]

I think this is quite easy question but I'm a beginner so help me please...

So, I just want to export data from forms (for example from textboxes) to normal worksheet cells.

What is the code to do that in VB?

Thank you!

 

[Rodie]

Easy ...

If you textbox is named Text1[/red] and that you want to copy its content in the Cell(A1) of the first sheet of your current Workbook :

ThisWorkbook.Worksheets(1).Range("A1") = Text1.Text

Ditto if you have a ComboBox : use .Text

Rodie

 

[PHV]

Take a look at the ControlSource property of the textbox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[episode80]

Thank you for your help! You really saved my day!