Use a Forms combox, create a data list on a sheet, link that list to the
combo, and the target cell. Just Right-click the combo, FormatControl tab.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marc" wrote in message
...
Hello world,

I would like to add combo box on Sheet1 and that combo have some values to
select. I know how to put combo box, although there are 2 ways, with Forms
toolbar and Visual Basic toolbar. I don't know what code to put in combo.

Then, I would like that value selected in combo is displayed in cell D10.

Your help is appreciated.
Thanks.