Can you remove the green triangle using VBA?

[rizzo93]

My code pastes a formula into a column of cells that also contains a data validation list. This formula returns information if it can find it. If it can't, then the user can select a value from the list in the cell.

As a result, I get a green triangle telling me there is a data validation error. I understand why it's doing this, but I don't care as this doesn't negatively impact the purpose of the cell. I just want the error to be ignored.

I've read about turning the error-checking feature off in the settings, but I prefer handling this using VBA, if possible.

How can I get rid of this triangle using VBA in all the cells affected?

 

[JEC]

Maybe with

Application.ErrorCheckingOptions.ListDataValidation = False

 

[rizzo93]

That worked, JEC! Thanks!

What's odd is that ListDataValidation wasn't among the other choices for this issue on the Microsoft help site.

But the triangles on gone now.

 

[JEC]

Great! Below on the help page it actually exists

 

[rizzo93]

That is a much different list compared to what I was referencing. It had half those values. But good to know. Thanks again.