Excel grays out menu commands for unavailable features or functions. To unlock the grayed-out menus, first review the most common causes, then take the steps necessary make the menu active.

Excel intuitively selects the list range, which usually consists of multiple columns. Click OK, and Excel will create the list shown in Figure B by adding drop-down controls to each header cell.

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.