Dropdown for whle column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Mosca, MS Access MVP - 03 Oct 2006 18:49 GMT

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.

Signature

Bill Mosca

Reply to this Message

Dave Peterson - 03 Oct 2006 19:21 GMT

Maybe you could use Data|Validation.

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

> Is it possible to create a dropdown box that will work for each cell in a
> column?
[quoted text clipped - 5 lines]
> --
> Bill Mosca

Signature

Dave Peterson

Reply to this Message

Bill Mosca, MS Access MVP - 03 Oct 2006 19:45 GMT

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

Signature

Bill Mosca

> Maybe you could use Data|Validation.
>
[quoted text clipped - 11 lines]
>> --
>> Bill Mosca

Reply to this Message