Persistent values in ListBox in Excel VBA
<p>This is my first question in this forum and I am very new to Excel VBA.</p>

<p>I have a text box that has an <code>Exit</code> event. My requirement is that when I fill that textbox and exit from there its values should be populated in ListBox. Now, when I am trying to insert the value again inside textbox, it overwrites previous value inside the ListBox. I want the values to be persistent. So the values entered in text box should come in sequence.</p>

<p>Here is what I tried : </p>

<pre><code>ListBox1.ColumnCount = 2 

ListBox1.AddItem 
ListBox1.List(0) = TextBox2.Text 
</code></pre>

<p>But then how can I take the next value from Text box and make it visible in List box...(so if I enter 3 values in text box it should show three rows in Listbox)</p>