Values in a Listbox onto a new row

[craig62]

Hi,

I'm fairly new to Excel VB. I have a userform and I want the user to input values into 3 boxes press an add button and then it adds it to a Listbox.

This is working fine for 1 line of data, but when I try to put a 2nd line of data it overwrites the first.

Here is the code I have at the moment:

Please Login or Register  to view this content.

Can anybody help me with this.

Thanks

[Fotis1991]

Welcome to the forum

Pls

Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future