Clearing list box on userform

[Josh_123456]

I am having trouble clearing a listbox on a userform


The only event I am using is the click event.


When someone clicks one of the choices it does the event associated with what they clicked. However, after they click, the cursor or hightlight remains on what was clicked, so in order to click it again, they have to click another entry, which causes another action, and then they can click back to the original one.

i tried listbox1 = "" after the code, but to no avail.

It just seemed to duplicate the action.


Is there anyway to make it where nothing is highlighted or selected in the listbox?


Thanks and I appreciate any help.


Josh

[Leith Ross]

Hello Josh,

Here are macros for both types of ListBoxes.

Please Login or Register  to view this content.

Calling DeSelect_2 Macro:
DeSelect_2 "ListBox1"

Sincerely,
Leith Ross

[royUK]

try

Please Login or Register  to view this content.