How to get data validation list

T

Ting

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
 
Top