Variable List Name Validation

[EB08]

In short, I'm assigning a variable to a cell that will house the name of a list as text that I want to use for data validation. The problem i'm coming accross is how to then use the variable in data validation syntax to set the text in the "=listname" portion of data validation. for example:

test = Range("l11")

Range("L18").vaidation.Add Type:=xlValidateList,_ AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=test"

What i'm trying to do is have the text in range("L11") enter into the red portion above as the name of a list. Any ideas? Thanks again!

 

[pgc01]

Hi

Try:

... Formula1[COLOR=black]:= "=" & test[/COLOR]

 

[EB08]

Worked great...Thanks.