i have a combo box in excel but i want to put some information in it from another sheet, however it wont work when i highlight the cells that i want, it will only enter the first row that i selected. how can i get around this?
ben

Hi Ben,

If You use datavalidation or the combobox from the Forms toolbar then You need to create a named range and then assign the rangename as source for the control, like =MyRange

Kind regards,
Dennis

yeh thanx i just tried this but it will only copy the first row of information into the combo box

Hi Ben,

It sounds as You have Your list in a row and that the first value is only available in the combobox.

AFAIK it is by design and need either be solved with a list in a column (manually or refer to the original list and use the TRANSPOSE-function) or with VBA.

The Datavalidation can handle a list in a row.

Kind regards,
Dennis