Listbox ... Showing Selected

[MOnika]

HI..

I am not sure how to put it.
I have 2 list boxes. I slect a value from one and put in
anohter. and i can remove also ...

My problem is that I want that if i select the 2nd list
box, the value for the 1st one still shows me selected.
WHich I dont want. It shows that dark blue ...showing that
i have selected htat value. how can i make it appear all
white...I hope this makes sense

thanks

 

[Patrick Molloy]

add this

listbox1.listindex = -1

If you have multi select on the listbox then you'd needto
loop through eact item
with listbox1
for i=0 to .ListCount-1
.selected(i)=False
Next
end with

Patrick Molloy
Microsoft Excel MVP