Listbox vba

The following example swaps columns of a multicolumn ListBox. The sample uses the List property in two ways:

• To access and exchange individual values in the ListBox.

  Vba listbox selected item

• Excel vba populate listbox from worksheet
• Vba userform listbox from range
• Vba listbox selected item text
• Vba listbox additem multiple columns

In this usage, List has subscripts to designate the row and column of a specified value.

• To initially load the ListBox with values from an array. In this usage, List has no subscripts.

To use this example, copy this sample code to the Declarations portion of a form.

Make sure that the form contains a ListBox named ListBox1 and a CommandButton named CommandButton1.

Support and feedback

Have questions or feedback about Office VBA or this documentation?

Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.