Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
be validated or not validated in a cell
In using vba, i want to know application yes or no validation check of specific cell. dim mycel as range if mycel.validation = true then msgbox "yes the cell have validation" else msgbox "no no, the cell is general." endif but, i don't know how to do. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
be validated or not validated in a cell
One way:
Dim mycel As Range Dim vald As Variant Set mycel = Range("D2") On Error Resume Next vald = mycel.Validation.Type On Error GoTo 0 If vald < Empty Then MsgBox "yes the cell have validation" Else MsgBox "no no, the cell is general." End If Hope this helps Rowan x taol wrote: In using vba, i want to know application yes or no validation check of specific cell. dim mycel as range if mycel.validation = true then msgbox "yes the cell have validation" else msgbox "no no, the cell is general." endif but, i don't know how to do. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple selection from and into validated cell. | Excel Discussion (Misc queries) | |||
Data Validated Cell Arrow not Appearing | Excel Discussion (Misc queries) | |||
Can I drag a validated cell down the column w/a different input/ro | Excel Discussion (Misc queries) | |||
Tab from a Validated Cell to another | Excel Discussion (Misc queries) | |||
Using fill handle - validated cell - protected sheet | Excel Discussion (Misc queries) |