Combo box for column

[Kmarie]

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

Kmarie wrote:
>
> 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

[Kmarie]

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

"Dave Peterson" wrote:

> 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
>
> Kmarie wrote:
> >
> > 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
>