Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try something like:
Sub TestValidation() 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 --- Of course if the active cell doesn't contain validation, the macro will error out. HTH Jason Atlanta, GA -----Original Message----- Hi everyone, I want to know how to distinguish between a cell that displays a drop down list in a cell and another that does not. Thank you. . |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jason
Your solution work fine Thank you very much and have a good day Ja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple drop down list validation | New Users to Excel | |||
Text size in validation drop-down list box | Excel Worksheet Functions | |||
validation list drop down box, how do I bring in text commands | Excel Discussion (Misc queries) | |||
data validation list drop down text format too small | Excel Worksheet Functions | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |