Hi this is a follow up from my previous post UserForm event.

How can I amend the code to show not Sum of numbers but List of numbers?

Code

[vba]
PrivateSub TextBox1_AfterUpdate()

With Worksheets("Sheet2")

Worksheets("Sheet1").Range("A1").Value = Application.SumIf(.Columns(2), Me.TextBox1.Text, .Columns(3))
End With

End Sub
[/vba]

Thanks,
Nix