| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if cell.validation is set
Dear All,
This codeline triggers an error if no validation is set (any value) If ActiveCell.Validation.Type = xlValidateList Then How can I first test if validation is set ? If 'ActiveCell.valudation is set ' then If ActiveCell.Validation.Type = xlValidateList Then ..................code........................ end if end if Thanks, Filips |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| 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) | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions | |||
Threaded Mode
