Jac

That's true. You can have List Validation and not have a dropdown, so the
right answer is a combination of the two

If .Type = xlValidateList and .InCellDropdown Then


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com


"Jac Tremblay" wrote in message
...
Hi Dick,
The .InCellDropDown property always returns TRUE, no matter if the cell
displays a drop down list or not (there must be a validation though).
' *****
Sub TestList2()
With ActiveCell.Validation
If .InCellDropdown = True Then
MsgBox "It's a drop-down list!"
Else
MsgBox "It's not a drop-down list!"
End If
End With
End Sub
' *****
This code does the job:
' *****
Sub TestList()
With ActiveCell.Validation
If .Type = xlValidateList Then
MsgBox "It's a drop-down list!"
Else
MsgBox "It's not a drop-down list!"
End If
End With
End Sub
' *****
Thanks to Jason Morin and to all of you.