Deselect items in list box on userform

hi,

I have a macro where I show a userform to the user. On this userform i have 3 listboxes. For the purposes of this question i will really only reference listbox1. I have created a "test macro" showing my problemm / question.

Basically, the user selects an entry in listbox1 .........using the listbox1_click sub-procedure i "do certain things". If i detect an error then i prompt the user to select another entry in listbox1.

My problem is that when i detect an error and i try to DESELECT the entry that was selected by the user in listbox1 .......i cant. In fact when the user selects an item in listbox1 and an error is detected my msgbox prompt is shown 2 times (dont know why) and the item selected in listbox1 is NOT DESELeCTED.

Any ideas?

If you have any questions please let me know.

hi mike7952 ,

that gets rid of showing the dialog box twice but what about deselecting the selected item in listbox1? how to do this?

thanks again! that showing of the listbox twice was giving me a headache!

thanks to a previous post i am now able to get rid of the msgbox displaying twice

However, after the msgbox disappears the first time the listbox1 item is still selected "highlighted" blue.

is there a way to like "reset" listbox1 so none of the items are highlighted or selected.

i am enclosing the file/macro

thanks. that looks like it might work. i guess there is no "easy" way to do it

thanks again.

well, i thought that might work. i tried it but for some reason its not working.

got it to work.

In my test macro that i put here......it worked by just exiting the for-loop but in my "real" program apparently i had to "exit sub" to get it to work. get it to work was done by clearing and then re-populating the listbox.