Great, perfect super, Thanks Tom! (and Nick HK)

"Tom Ogilvy" wrote:

Private Sub ListBox1_MouseDown(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ListBox1.ListIndex = -1
End Sub

--
Regards,
Tom Ogilvy


"NezRhodes" wrote in message
...
Nick

I added this line of script to the end of my macro:

ListBox1.ListIndex = -1

and unfortunately it does not reset the listbox. Can you clarify your
answer
a little please?

"NickHK" wrote:

Set its .ListIndex to -1

NickHK

"NezRhodes"
...
Hello Gurus - I have written a macro on the back of a listbox button
that
allows the user to select a worksheet to update. However, once a
selection
is
made the list box retains this choice so the user cannot select the
same
choice again. How do I reset the listbox so none of the options are
selected?

Thank you in advance!