Adding multiple lines of text to textbox from combobox selection

[isaacv22]

Hello I'm trying add multiple lines of text to text box based off of values in ComboBox1 and 2. I get the text to show up when I make a selections on combobox1 but when an additional value on combobox2 is made it overwrites the text instead of add it to a new line. Below is the code, any assistance will be greatly appreciated.

Private Sub ComboBox2_Change()

Dim i As Long, LastRow As Long, ws As Worksheet

    Set ws = Sheets("Sheet2")
    
    LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row
    
        For i = 2 To LastRow
            If Me.ComboBox2.Value = ws.Cells(i, "A") Then
          
            Me.TextBox1 = vbNewLine & ws.Cells(i, "B").Value
            
            Me.TextBox2 = vbNewLine & ws.Cells(i, "c").Value
            
    End If
    
    Next i

End Sub

Private Sub ComboBox1_Change()

Dim i As Long, LastRow As Long, ws As Worksheet

    Set ws = Sheets("Sheet2")
    
    LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row
    
        For i = 2 To LastRow
            If Me.ComboBox1.Value = ws.Cells(i, "A") Then
          
            Me.TextBox1 = ws.Cells(i, "B").Value
            Me.TextBox2 = ws.Cells(i, "c").Value
            
        ElseIf Me.ComboBox1.Value = "" Then
        
            Me.TextBox1.Text = ""
            Me.TextBox2.Text = ""
                
            
            
    End If
    
    
    Next i
    
End Sub

Thanks,

 

[davesexcel]

For i = 2 To LastRow If Me.ComboBox2.Value = ws.Cells(i, "A") Then Me.TextBox1 = vbNewLine & ws.Cells(i, "B").Value Me.TextBox2 = vbNewLine & ws.Cells(i, "c").Value End If

If you want to add to the textbox, you need to include the textbox text
Something like

textbox1=textbox1 & vbnewline & newText

 

[isaacv22]

Dave,

I put that code in comboBox2_Change and it didn't work. I believe it's because the values selected in both combobox 1 &2 are the values form column A from a table I'm referencing on sheet2. When a value matches what is in column A it will pull the respective text from columns B and C. Not sure how much this helps, but I figured I'd try and more detail of what i'm trying to do with this code.