Printing Data Valiadation (1 Viewer)

[mdjks]

I have a spreadsheet with quite a few cells that have validation. This was put in via the data validation dialogue box rather than refering to a range. Is there any way to print out all of the choices?

 

[unmarkedhelicopter]

You can type in the imediate box :-
?Selection.Validation.Formula1
Which will print the validation list for the currently selected cell to the imediate window
I could also write you a UDF (User Defined Formula) to allow you to enter say =ValListGrab(A2) to have the same written to a cell :-

Function ValListGrab(rRange as Range) as string
    ValListGrab = Range(rRange).Validation.Formula1
End Function

I haven't tested this so it 'may' need tweaking.