Check if cell has data validation with VBA ~ Working Excel Macros

Uncategories Check if cell has data validation with VBA

Check if cell has data validation with VBA

Check if cell has data validation with VBA:

checking if the cells in excel has data validation or not.

for checking the data validation here is the excel macro.

Sub test()
    On Error Resume Next
        If ActiveCell.SpecialCells(xlCellTypeSameValidation).Cells.Count < 1 Then
            MsgBox "Active Cell does not have validation"
        Else
            MsgBox "Active cell has Validation"
        End If
    On Error GoTo 0
End Sub

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.