Add List Box to Excel Worksheet

In some workbooks, you want users to select one or more from a list of options. To make it easier for people to enter data, you can add a List Box, with check boxes, to an Excel worksheet.

ListBoxDaysSelect06

You wouldn’t want to have too many List Boxes on a worksheet, but it would be handy in a data entry form, like this one.

VolunteerListBox01

In worksheets where you need several cells with multiple options, you could use the technique for selecting multiple items from a data validation drop down.

Set Up a List Box

On the Contextures website, there are instructions for setting up a List Box, and a sample workbook. You can enter records, one at a time, on the data entry sheet, and run the macro to store the saved records another sheet. The code pulls the selected items from the List Box, and stores them in separate cells.

VolunteerListBox02b

Watch the List Box Video

To see the steps for creating a List Box on a worksheet, please watch this short Excel video tutorial.

____________

You may also like...

1 Response

  1. Ahmed says:

    How we can make the list fill range for 2 or more columns, for example: =Lists!$A$1:$B$5

Leave a Reply to Ahmed Cancel reply

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