| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for existance of data validation
Could someone provide syntax to test for data validation within a cell? I
can't seem to get it to work. Thanks, Pflugs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Test for existance of data validation
Dim dv
On Error Resume Next dv = ActiveCell.Validation.Type On Error GoTo 0 If Not IsEmpty(dv) Then MsgBox "validation" End If -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pflugs" wrote in message ... Could someone provide syntax to test for data validation within a cell? I can't seem to get it to work. Thanks, Pflugs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Test for existance of data validation
Thanks. I was trying to use "Is Nothing".
Thanks, Pflugs "Bob Phillips" wrote: Dim dv On Error Resume Next dv = ActiveCell.Validation.Type On Error GoTo 0 If Not IsEmpty(dv) Then MsgBox "validation" End If -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pflugs" wrote in message ... Could someone provide syntax to test for data validation within a cell? I can't seem to get it to work. Thanks, Pflugs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB syntax to test for data validation in a cell | Excel Discussion (Misc queries) | |||
| Test in Validation Box Very Small Font Size... | Excel Discussion (Misc queries) | |||
| Test if cell.validation is set | Excel Programming | |||
| Test for for sheets existance | Excel Programming | |||
| VBA test for the existance of a worksheet. | Excel Programming | |||
Linear Mode
