Can I print data validation comments

S

sandy0913

I would like to print out data validation comments. When I select view
comments data validation does not appear. How can I print entered data
validation
 
J

Jim Rech

Since there is no printing option specific to validation input messages you
might try listing them in a sheet with a macro, and then printing that.

Sub ListValidationInputMsgs()
Dim ValRg As Range
Dim Cell As Range
Dim Counter As Integer
On Error GoTo NoValidations
Set ValRg = Cells.SpecialCells(xlCellTypeAllValidation)
Worksheets.Add
For Each Cell In ValRg
Counter = Counter + 1
Cells(Counter, 1).Value = Cell.Address(False, False)
Cells(Counter, 2).Value = Cell.Validation.InputMessage
Next
Exit Sub
NoValidations:
MsgBox "No validations on sheet"
End Sub


--
Jim Rech
Excel MVP
|I would like to print out data validation comments. When I select view
| comments data validation does not appear. How can I print entered data
| validation
 
Top