"Jack Zhong" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---