data validation

[Jack Zhong]

Hi, all,

Rather than VBA codes, are there any other ways to validate the cell's value
which is set by the underlying formula?

 

[Max]

Rather than VBA codes, are there any other ways to validate the cell's value
which is set by the underlying formula?

Perhaps try a look at Debra's nice coverage at:
http://www.contextures.com/xlDataVal07.html
Excel -- Data Validation -- Custom Validation Criteria Examples

 

[Jack Zhong]

Thank you, it is just what I am looking for.

Perhaps try a look at Debra's nice coverage at:
http://www.contextures.com/xlDataVal07.html
Excel -- Data Validation -- Custom Validation Criteria Examples

 

[Max]

Thank you, it is just what I am looking for.

Glad to hear that, Jack !
Thanks for the note-back ..