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.

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.

I would like to create data list in VBA. How to do this?

Thanks

Define what !you! mean by data list.

--

HTH

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


"Marc" wrote in message
...
I would like to create data list in VBA. How to do this?

Thanks

Thanks,

I have managed like you said, I thought I have to add values (for selection
in combo) through VBA. I didn't know I could do it by Format, Control Tab.