MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop down buttons


Posted by Ciara Coughlan on July 26, 2001 7:15 AM

Hi,

I am trying to use a combo box to enter a drop-down list of names, subjects in a spreadsheet, the help pages in Excel mention the input range but I can't figure out where to populate it?

Any ideas????????

Thanks...


Posted by mseyf on July 26, 2001 11:00 AM

if you're using the combo box from the 'Forms' toolbar, right-click on the combo box and select 'Format Control...' and go to the control tab.

if you're using the combo box from the 'Control Toolbox' toobar, activate the design mode button (blue triangle w/pencil) and the properties button (finger pointing on page) and enter your range in the 'ListFillRange' property.

HTH

Mark