Mandatory Cell - If one cell contains information, then another must.

[tfg1067]

Hi, I've been using this code to make sure a document cannot be saved without the required information being filled in, but I wondered if there is a way to make it a little smarter.

It would be best if it was something like "If C4 contains information, then C5, B6 must". It would be good if a window popped up as well, stating that the related cells need to have information entered. I've searched the forum, but I haven't found anything directly related this this yet. Any input would be appreciated!

Please Login or Register  to view this content.

[p24leclerc]

It would be something like this:

Please Login or Register  to view this content.

regards

[tfg1067]

Thanks! That works if information in C4 is mandatory. But what if I only want it to check C5 and B6 if information is put in C4?

[p24leclerc]

It would then be:

Please Login or Register  to view this content.

[tfg1067]

Thanks guys, works great!