Save the file as macro enabled workbook.Now all ListBox1 Items are available in ListBox2.

Select 3rd Button and Rename it as “cmdMoveSelLeft” and enter Caption as “>” button.

Select 2nd Button and Rename it as “cmdMoveSelRight” and enter Caption as “>”.

Rename 1st button Name as “cmdMoveAllRight” and enter Caption as “>”.

Select 1st Button and then Right Click Goto Properties and click on it.

Insert two ListBox’s and four Buttons from ActiveX Controls.

ListBox VBA Excel -Sample ListBox Design:

Move selected Items from ListBox2 to ListBox1.

Move selected Items from ListBox1 to ListBox2.

Move all Items from ListBox2 to ListBox1.

Move all Items from ListBox1 to ListBox2.

Load Items to ListBox while opening Workbook.

In this tutorial, we will explain different example on using ListBox in VBA Excel. You can show the list of items in the listbox and user can select any item and do different operations.

VBA ListBox in Excel is one of finest control in the Excel. ListBox VBA Excel Example Macros Codes for Adding new Items,Moving all Items, selected Items from ListBox to another ListBox,clearing,Multi selection.

Visual basic for excel starter