MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Help with Drop Down Boxes within cells

  Asked By: Egidius    Date: Feb 15    Category: MS Office    Views: 815

question regarding creating
drop-down boxes in cells.
The boxes will all have the same list of text items.
This box must appear in 100 or more cells in the same worksheet.

Is there a cut/paste or copy option to easily set the drop down list
and contents into many cells - quickly?

This sheet is used to track shipping progress of shipments sent by
truck. I am monitoring locations/progress of 20-30 trailers each day.



3 Answers Found

Answer #1    Answered By: Shirley Allen     Answered On: Feb 15

Create the list  of items  to appear in the dropdown list in a range (could be on
another sheet.) Select all the cells  in the range, then assign the range a name
(Insert >> Name >> Define). Assume you named the range TheList. Select the first
cell which should display the list as a dropdown box. Select Data >> Validation.
On the Settings tab of the Data Validation dialog that appears, select List in
the Allows dropdown box. In the Source textbox, enter =TheList and click OK.
This creates the dropdown based on the named range. You can copy & paste this
cell; wherever you paste it will have the same dropdown list. This also lets you
maintain the list in one place: the named range (TheList).

Answer #2    Answered By: Myrna Brown     Answered On: Feb 15

Thanks for the clear explanation. As usual, I learned
something new from ExcelVBA today!

Answer #3    Answered By: Reginald Thomas     Answered On: Feb 15

I believe you can also select a range of cells  (including an entire
column / row) THEN do the select Validation setup from the menu.

Selecting Validation from the menu should bring up a mini-wizard
where you can select the list-range, default cell as well as error
messages should the user violate your guidelines.

Didn't find what you were looking for? Find more on Help with Drop Down Boxes within cells Or get search suggestion and latest updates.