Hi, I recently bought the Excel 2003 VBA book from Wrox to get some support about VBA in Excel. Despite the information and tips out the book, I still can’t solve a problem. I want to merge twenty-five text strings in a text box. These text strings are generated from another sheet and are changed automatically. Is there a way to make a macro, which will place these merged text strings, automatic in the text box?
Thanks in advance

Hi,

Depending on where your data comes from, try this:
The subroutine below here can be made in the Sheets-code in VBE.
The worksheet must also be the sheet where the changes are made.

Private Sub Worksheet_Change(ByVal Target As Range)

For i = 1 to enddata
   newstrg = Sheet2.Cells(i,1).Value
   strng = strng & newstrg
next i
Sheet1.Textbox1.text = strng
End Sub