Repetitive combo box for column in Excel 2007

[kwvh]

I have been asked to assist in placing a combo box in a column on a spreadsheet. I can see how to add it as a control to a form or as and activeX object, but not how to have the combo box available in every cell in the column. They may be asking me for the wrong tool for the job. The cells in the column should only allow yes, no, or null. Is there a better way than a combo box? Would a VBA module be the best approach and then just valid the data after the cell has been updated?

As most of you know, I am an Excel novice.

Thanks in advance for your ideas and suggestions.

Ken

[StuartR]

From what you have described, I think the most likely solution would be a data validation list.

[kwvh]

Stuart,

AWESOME! Exactly what they needed.

I love this place!

Ken

[HansV]

Also see the links at the end of Excel Data Validation Introduction for some of the cool things you can do with validation lists.

[kwvh]

Wow! Excellent explanations, samples and options.

Where and how do you find all these resources?

Thanks, Hans