Multiple List Validation

[wbf313]

I'm building a list box in excel using a named range. This isn't all that I'm trying to do, I need to add a named range to the list as well as static cell values WITH the named range. Any ideas?

 

[Luke M]

Is your list box from the Forms menu, or ActiveX menu?

 

[wbf313]

It's under Forms

>Data > Data Validation

 

[Luke M]

Also, any chance you could move, or provide links to, the static cells so that all the values are in the same range?

 

[wbf313]

Here's what I have:


named range{1,2,3,4,5,6,7,8,9,10} (the numbers are values in the named range)

It's clear that you can create a validation list out of a named range by itself.


The problem is combining a named range with static cells so that the list validation consists of:


{1,2,3,4,5,6,7,8,9,10,cell,cell,cell,cell} where "cell" is a static cell reference.


I've tried making the list of cells a named range, and combining the two, but it doesn't work the way that I want it to. I get an error..You get me?

 

[NARAYANK991]

Hi ,


Do you think the following can help ?


http://www.contextures.com/DataValMultiLists.zip


The above file , which contains the sample workbook , is from this link :


http://www.contextures.com/excelfiles.html


Narayan