Combo box for column

[Guest]

How do I make a combox box throughout an entire column? For example, if each
row is a new record, I want a combox box each time I get to column F.

 

[Dave Peterson]

Have you thought about using Data|Validation with a list on a different
worksheet?

Select your range of cells in column F and then Data|Validation.


Debra Dalgleish has some very nice notes if you've never used this feature
before:
http://www.contextures.com/xlDataVal01.html

 

[Guest]

Thank you! I have never used Data Validation before and that link was perfect.