Last week, we saw how to move items from one listbox to another on an Excel worksheet.
Now I’ve added a page on the Contextures website, with similar instructions for listboxes on an Excel UserForm. Thanks to Dave Peterson, who provided both sets of sample code.
Download the Move Listbox Items Sample File
To see the code, and test the ListBox move items code for a UserForm, you can download the ListBox UserForm Move Items sample workbook. The file is in Excel 2007 format, and is zipped. It contains macros, so enable them if you want to test the code.
Related Excel VBA Tutorials
If you’re looking for a way to fill your holiday Monday, here are a few other UserForm and Excel VBA tutorials on the Contextures website:
- FAQs, Excel VBA, Excel Macros
- Create an Excel UserForm Video
- UserForm with ComboBoxes
- Excel VBA Edit Your Recorded Macro
- Excel VBA Getting Started