How to get data validation list
 

Hi,

How can I get a cell's validation list in VBA code?

I know the list can be input manually or programatically
using "Validation.Add", but how to retrieve it in code?
I want to know the valid input range of some cells in an Excel file.

Thanks in advance.

Ting

How to get data validation list
 

Try:

ActiveCell.Validation.Formula1

In article ,
"Ting" wrote:

Hi,

How can I get a cell's validation list in VBA code?

I know the list can be input manually or programatically
using "Validation.Add", but how to retrieve it in code?
I want to know the valid input range of some cells in an Excel file.

Thanks in advance.

Ting

How to get data validation list
 

Thanks! Just it is.

Ting

"JE McGimpsey" дÈëÓʼþ
...
Try:

ActiveCell.Validation.Formula1

In article ,
"Ting" wrote:

Hi,

How can I get a cell's validation list in VBA code?

I know the list can be input manually or programatically
using "Validation.Add", but how to retrieve it in code?
I want to know the valid input range of some cells in an Excel file.

Thanks in advance.

Ting