Transfering data form to form

[bopo]

Hiya People

Jusr wondering how I can transfer data between forms, .e.g taking data from a text box and placing in into another text box on a form?

thanks.

[lucas]

Guessing that you mean another textbox on a different form:
[VBA]
Me.TextBox1.Text = UserForm1.TextBox1.Text
[/VBA]

[bopo]

Thanks, looks like it works, however I want all the info to automatically appear on the new form, rather that clicking a button to display the information.

Would I need to use something like

Private Sub tTextbox1_AfterUpdate

or something similar?

[mdmackillop]

Hi Bopo.
How are you opening the new form?
Data can be added to it using the Userform Initialize event. Do you anticipate entering data on the spreadsheet while a Userform is displayed?

[bopo]

Hi Bopo.
How are you opening the new form?
Data can be added to it using the Userform Initialize event. Do you anticipate entering data on the spreadsheet while a Userform is displayed?

Erm okay....


Bascially a user in going to fill details into a form, such as name, costs etc, then a button on this form will be clicked, which will open a new form and display some of the details from the previous form for verication purposes and results of calculations will also appear on the form.

[mdmackillop]

You could possibly use a multipage control on the form, rather than multiple forms.

[bopo]

Anyway, I have put it behind a button, no problems. however anthoer question

I want to add data from 2text boxes into on another 1 lstbox, how do I do this?

[mdmackillop]

Here's a simple example

[new2006]

thanks