Removing item from one listbox to another Code Issue

Hey there,

Love these forums, so helpful!

Here's my (new) issue. I have 2 list boxes: left one with existing brands and right one with selected brands. The user clicks on the item in the left box, presses the command button, and the item goes to the right box...No problem there. THE PROBLEM: What is wrong with my code below is the item from the left hand side should be removed when it is commanded to the right hand side. In other words, my selected item is moving to the right side box, but not deleting itself from the left side box!

Thanks for any help...

The error code I get is with the following line:

FrmNewSeason.lstExistingBrands.RemoveItem iCtr

Code:

Please Login or Register  to view this content.

Cheers for any help or insight!!

Hey Norie, thanks for inquiry,

Run time error, unspecified error--Then it highlights the following line:


FrmNewSeason.lstExistingBrands.RemoveItem iCtr

Could it be because the left side list, lstExistingBrands, is populated by the properties RowSource, and not populated on activate?

Hey Norie, thanks for the input. I also think it's not responding to remove because I have populated the list from properties when the FrmNewSeason opens.

I have changed my code as shown below...now however, I'm not getting any response from my Rowsource...Nothing is popping up in the left side list box!!

Code to activate list when I click on button btn_NewSeason:

Please Login or Register  to view this content.

Code to pass selected tems from left to right:

Please Login or Register  to view this content.

Thanks again for any input!

Nevermind...Got it to work..Indeed, adding that one line you suggested on userform activate has solved this issue..Thank you very much Norie for your simple and wse input!!

Both of those work indeed...I was activating the wrong userform!! (roll eyes!!)

Thank you very much for your time and help!