Dropdown for whle column

[Bill Mosca, MS Access MVP]

Is it possible to create a dropdown box that will work for each cell in a
column?

Example:
Dept in Column D needs a dropdown to allow user to select from list in each
row.

 

[Dave Peterson]

Maybe you could use Data|Validation.

See Debra Dalgleish's site for a bunch of instructions:
http://www.contextures.com/xlDataVal01.html

 

[Bill Mosca, MS Access MVP]

Thanks, Dave. That gave me all the info I needed.