Programmatically Extracting Validation List
 

I have a selection that has a validation list attached to it and I'd like to
extract the list that's tied to it programmatically. How would I go about
doing that?

Thanks,
Barb Reinhardt

Programmatically Extracting Validation List
 

Say you want the data validation list associated with the active cell

dim address as string
dim rg as range
address=activecell.Validation.formula1
set rg=application.range(address)

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Barb Reinhardt" wrote:

I have a selection that has a validation list attached to it and I'd like to
extract the list that's tied to it programmatically. How would I go about
doing that?

Thanks,
Barb Reinhardt

Programmatically Extracting Validation List
 

ACtually Formula1 returns '=' in front of the range address. So instead, use:
address = strings.replace(activecell.Validation.formula1,"=" ,"")
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"sebastienm" wrote:

Say you want the data validation list associated with the active cell

dim address as string
dim rg as range
address=activecell.Validation.formula1
set rg=application.range(address)

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Barb Reinhardt" wrote:

I have a selection that has a validation list attached to it and I'd like to
extract the list that's tied to it programmatically. How would I go about
doing that?

Thanks,
Barb Reinhardt