In some workbooks, you want users to select one or more from a list of options.
Select Items in a List Box
To make it easier for people to enter data, you can add a List Box, with check boxes, to an Excel worksheet.
List Box on Data Entry Sheet
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.
- Tip: In worksheets where you need several cells with multiple options, you could use my 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.
Store Selected Items
The List Box macro code pulls the selected items from the List Box, and stores them in separate cells.
Watch the List Box Video
To see the steps for creating a List Box on a worksheet, you can watch this short Excel video tutorial.
____________
How we can make the list fill range for 2 or more columns, for example: =Lists!$A$1:$B$5