ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox (https://www.excelbanter.com/excel-programming/443904-listbox.html)

K[_2_]

Listbox
 
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

GS[_5_]

Listbox
 
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




All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com