this code worked. however i just realized that i could not achieve what i wanted with it.
what i actually wanted to do is to remove some characters from the first listbox and put the remaining characters in the second listbox, can you help out with this?
this code worked. however i just realized that i could not achieve what i wanted with it.
what i actually wanted to do is to remove some characters from the first listbox and put the remaining characters in the second listbox, can you help out with this?
You could assign the values of the first listbox to an array and then make your changes to the array. Once those are made, you can assign the array to the 2nd listbox like this:
array() = ListBox1.list
'Make your changes to the contents in the array
ListBox2.list = array()
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.