Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.

How to Make a Drop Down Box to Allow Multiple Selections in Excel. Microsoft Excel allows you to create a drop-down list that gives you the ability to choose values or items listed in one cell.