Simple Function to Test for Data Validation STRANGE ISSUES

[yay_excel]

I have written what I consider to be a very simple function to test a cell for data validation but clearly I am missing something. The function returns true when it should return false and, after being run once, I receive a Function not defined error.

I have rewritten it many different ways; here is the current version:

Please Login or Register  to view this content.

The function is stored in my PERSONAL.xlsb workbook and I am testing the function through the Immediate window of the VBE. I have tried referring to ActiveCell as well as a range with the same results. It works once but doesn't necessarily return the correct value and then I receive the "Sub or Function not defined" error on subsequent attempts.

No clue why this isn't working.

[xladept]

I ran it like this with type 1 validation in G14 and it ran nicely:

Please Login or Register  to view this content.

[yay_excel]

When I test it through a sub instead of through the immediate window, it runs nicely for me as well. It still will not run from the immediate window. Strange. Thank you for your help.

[xladept]

I never use the immediate window, I suspect that there is some protocol that your violating wrt the immediate window

[yay_excel]

Huh. I have been using it since I discovered it when I began programming a few years ago and have never encountered any behaviour I didn't expect. I will always test using something else now that I know it has its own ideas sometimes.