Collate Data using User form

[Aj Lapinig]

Hi Folks,

I'm trying to collate all data from text box using user form in excel 2007. is anyone can help on how to do this? i wanted to collate data from text box 1 to 5 and appeared everything in text box 6...or it's like generating notes.....

 

[Trevor G]

Welcome to the forum,

If I read this write you want to copy the text in a textbox and concatenate it into another textbox on a userform?

If so then you only need to use something like

textboxResult=textbox1 & " " &textbox2 & " "&textbox3 etc

If you need the results to be on multiple lines then you need to make sure the property for multiple lines have been set.

 

[Aj Lapinig]

Hi Trevor,

What i am trying to do is to collate all data is like this ; collate all the text data from textbox1 to textbox5 into textbox6(summary of the collated data) once i press the command button (generate notes)

 

[Trevor G]

In your command button then you need the code I added just change the textbox names to the once you have. You will need to make sure that the what ever gets typed in will fit in ie the amount of text.

 

[Aj Lapinig]

I did but it will not go to the text box3 all the info i encoded in text box1 and 2 once i push the command button