Cell Data Validation with dynamic Range

[Arishy]

Can I use the following code:

With ActiveCell
.Validation.Delete
.Validation.Add xlValidateList, , , "=" & "ListRange"
End With

with several cells in a column BUT using for each SPECIFIC cell a
SPECIFIC ListRangexx

Example:

Cell "A1" Value: 85 this cell will use Data Validation ListRange85
which is a range to use with value 85
Cell "A2" Value: 86 this cell will use datavalidation ListRange86 which
is a range to use with value 86

These ranges(ListRange85" , ListRange86 ) are dynamic They will be
Created from an Imported Table to this workbook

Here is the Layout of that table:

Item/Price
1185/$.5
2285/$.6
3386/$.7
4486/$.8
5586/$.9

The ListRange85 will contain two Validations 1185 and 2285
The ListRange86 will contain three Validations 3386 ,4486 and 5586

So When I select cell A1 I get to choose between 1185 and 2285

I hope I made myself clear enough



The ListRange85 is dynamically filled each time I open a wb from a
onother table imported to this workbook

 

[Norman Jones]

Hi Arishy,

I am not clear about your intention.

However, see Debra Dalgleish's Dependent List page at:

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


See also, xlDynamic's Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html