Create Multiple Selection Listbox in Excel VBA

Share Now

You gonna get more information about Excel VBA Training in Gurgaon. In this article, learn how to create multiple selection list box in Excel VBA. We will be using User form, ActiveX List box control and a command button in this.

User form will show a grocery list in the list box and we can select the multiple items from the list box. By clicking on the Add item button, we can add multiple items in the worksheet.

create Lisbox in excel

In this Article How to create multiple selection list box in Excel VBA. It Includes

  • How to create user form
  • How to create Listbox
  • Adding Items to the list box
  • Multiple Selection in the list box
  • On click of command button, get the list in the worksheet and Total sum of amount
  • How to write Sum function with variable in VBA

Click Here to download sample workbook template

Create User form

Open Visual Basic for Editor. Click Insert Tab, USerform.

Learn how to create multi selection listbox in Excel vba

Add Items in the Listbox

A blank user form will appear. Now drag list box from the Toolbox in the user form. Add one command button too.

Listbox in Microsoft Excel VBA

Read on Excel VBA Training in Gurgaon…

Now select list box and add items to it from property window.

Go to Row Source and write the list range address (In our downloaded template we have data in List sheet and address is List!Range(“A2: B40”)) and Multiselect option as “1 – frmMultiSelectMulti”

Create multiple selection listbox in excel
excel vba training in gurgaon

Now change the name and caption of command button and user form from property window.

User form:
Name: Grocery list
Caption: Grocery List

Command Button:
Name: addiemscmdbtn
Caption: Add Items

Now double-click on the Add Item command button and update below code.

Create multiple selection list box in Excel VBA

Ready to learn the next level? Want to feel like excellence in this?
Check out more in excel VBA training in Gurgaon today.

Share Now

0 responses on "Create Multiple Selection Listbox in Excel VBA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


    0124- 4601426


    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED