copying text from 1 text box to another

[slmi1313]

Hello All,

I have created 4 text boxes in excel using the control toolbox. 1st box is called Name,2nd is called Date, 3rd is called Amount and the 4th is called Main.

My users will enter the info in the 1st,2nd and 3rd text box, now I have created a command button next to each of these text boxes to copy the info into the 4th text box called Main. The command buttons are all called Go What would be the code that I would need to enter in those command buttons... Can that be done?

[rylo]

Hi

Does each button copy the data from the 3 text boxes into the 4th, or does it only copy the data from the one next to it? And what does it do with any existing data in the 4th textbox? Overwrite, append???


rylo

[slmi1313]

only from the one next to it, and when it copies it in the 4th text box it has to follow any other text that is in that 4th text box

[slmi1313]

Rylo, do you have anything for me, my project is almost done but Im stuck any help would be greatly apreciated

[rylo]

Hi

Each button will have code along the lines of

textbox4.text = textbox4.text & " " & textbox[1,2,3].text

where the [1,2,3] will relate to the textbox to the left of the specific button.

rylo

[slmi1313]

wow you are the best thank you so much