Reset List Box Object

[Noah114]

I have a List box the pops up in excel with the cell is selected. Each cell in the column when selected with pop up with the same list box because I made a form. However, if I make an entry, complete it, and move on to the next row to make another entry the list box opens in the desired cell but with the previos selection marked. Here is my VBA, is there a reset or clear action?

Private Sub listBox1_Click()
ActiveCell.Value = ListBox1.Text
Me.Hide
End Sub

 

[kjv1611]

How about:

lstMyListBox.Requery