Show data from textbox in a listbox using VBA

Hi

Is there a simple way to extract data put in a textbox to be shown in a listbox using VBA?

I have a used the following code:

Please Login or Register  to view this content.

This only works the first time I put data in the textbox. In the second time, it throws up an invalid property error.

Cheers

Place text in text box, then run code below.
You need to run the code after you've entered the text, as in a commanbutton.

Please Login or Register  to view this content.

Thankyou both. This has been a great help.