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