Creating a drop box in a workbook.
 

I am trying to create a drop box in a workbook. The problem I seem to be
having is in understaning how to do this. The data I would like to use in on
another sheet and the data Items spans 5 columns. I would like to make a
simple drop box that has about 10 items in it, but I am having no success
following the help directions,
--
Thanks in advance for your help

Creating a drop box in a workbook.
 

Mark

You can use a simple Data ValidationList dropdown with a couple of rules.

1. The list data range must be in one column.

2. The list data range, if on another sheet, must be a named range.

You could just type the 10 items into the list dialog box.....comma de-limited.

i.e. item1,item2,item3

For more on DV lists see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

You may be able to use a combo-box instead but I have very little experience
with those. Debra's site has info on those.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Fri, 19 Jan 2007 12:25:47 -0800, Mark wrote:

I am trying to create a drop box in a workbook. The problem I seem to be
having is in understaning how to do this. The data I would like to use in on
another sheet and the data Items spans 5 columns. I would like to make a
simple drop box that has about 10 items in it, but I am having no success
following the help directions,