Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish to validate the data in cell B3. I can readily set up a custom
validation using a formula such as =AND(B3=0, B3<=100) I would like to use a VBA function that I have written called IsValid(). However, if I attempt to enter a custom validation formula of =IsValid(B3) I receive the message "a named range you specified cannot be found". Where am I going wrong? Can't I reference a VBA function in this way? The function appears to work if I use it in a normal Worksheet formula. For example, if I enter =IsValid(A3) in cell A4 then A4 correctly displays either TRUE or FALSE depending on the value in A3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation within a worksheet | Excel Discussion (Misc queries) | |||
Data Validation to different worksheet | Excel Discussion (Misc queries) | |||
How can i put data Validation on a different worksheet | Excel Discussion (Misc queries) | |||
Data Validation Combine Functions | Excel Worksheet Functions |