thanks, but I need a combobox so that it can perform auto-complete or match
entry...

"Kevin B" wrote:

You can do that with Data/Validation on the Excel menu by pre-selecting the
range that requires the drop-down list and specifying the range where the
list is located.
--
Kevin Backmann


"sedonovan" wrote:

Is is possible to copy a combobox (and all its properties) into a whole
column? Each cell should have the drop down button.

Many thanks