K submitted this idea :
Hi all, I have two listboxes on the sheet and a command button. I
have macro on the button which moves items from Lisbox1 to Listbox2.
I need some kind of code that if i move item twice from Listbox1 to
Listbox2 then i should get message box saying that "You already have
moved this item" etc. Please can any friend can help me on this

I guess you need to first explain why the moved item is still in
Listbox1. It suggests you are COPYING the items to Listbox2, not moving
them.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc