Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation question
Hello,
In Excel you can select "Data" then "Validation" & then set data validation on Cells. I was looking at the VBA Validation Object seeing how to progromatically Add, Delete, or Modify Data Validation. But what I want to know is, is their a way through VBA code to tell if a Cell has Data Validation on it or not, bsaically returns True or False. For for example if I select Cells(1,1).select, is their Data Validation on it ? Any help would be greatly appreciated. Thank you, Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation question
This worked in Excel 2000
Dim x On Error GoTo errorhandler x = Range("E1").Validation.Type = 1 MsgBox "yes" Exit Sub errorhandler: On Error GoTo 0 MsgBox "no" -- steveB Remove "AYN" from email to respond "Jeff" wrote in message ... Hello, In Excel you can select "Data" then "Validation" & then set data validation on Cells. I was looking at the VBA Validation Object seeing how to progromatically Add, Delete, or Modify Data Validation. But what I want to know is, is their a way through VBA code to tell if a Cell has Data Validation on it or not, bsaically returns True or False. For for example if I select Cells(1,1).select, is their Data Validation on it ? Any help would be greatly appreciated. Thank you, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation (lis) question | Excel Worksheet Functions | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation Question? | Excel Worksheet Functions | |||
Data validation question | New Users to Excel | |||
data validation question | Excel Programming |