| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set data validation in VBA
In the Worksheet_Change event, I want to change data validation depending on
certain entries in the spreadsheet. When the VBA gets to the following code: Range("A5").Validation.Delete Range("A5").Validation.Add Type:=xlValidateCustom, Formula1:="=COUNTIF(INDIRECT($K$27),A5)=1" where K27 = "A5:A13", and I don't want a duplicate in A5:A13. I get the following error message: "Method 'Add' of object 'Validation' failed". Does anyone know why my VBA won't add data validation? Thanks in advance for any help. Brad E. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Threaded Mode
