list box

[rds207]

how to insert a list box or a combo box in excel 2007?

[martindwilson]

they are in the developer tab
click office button
excel options
click on show developer tab
once you have done that
click on tab
click insert and there they are

[rds207]

how do i insert a list box or a combo box, in my coloumns?basically i want to have a select criteria for all my coloumns

[Paul]

Hi Rds, did you read Martin's post? With a bit more detail..

1. Click the Office button (round button in top left corner of application)
2. Click Excel Options
3. On the Popular view (Popular is shown by default), click the checkbox for "Show Developer tab in the Ribbon"
4. Click OK

In the Ribbon you'll now see a Developer tab. Click it, and in the "Controls" section click the Insert button. You'll then see the available Forms and ActiveX controls.

[rds207]

thank you paul, is there any link where i can get the basic infomation about excel,where i can learn?

[ChemistB]

See the second sticky post in this forum (Excel General) titled Excel Useful Links (see last post for new additions). Hope that helps.

[Palmetto]

If you're just looking to have a drop down list of items users can select from take a look at using Data Validation with the list option.