Ria InfoTech: The fun things to know about computers

Have more fun and be a more knowledgeable person by knowing the fun things about computers here at Ria InfoTech. The fun things you need to know about computers are:

About Us

Ria InfoTech is a leading Information Technology Company providing services in Networking, Computer Software, and IT solutions. We are committed to delivering innovative solutions that help our clients in achieving their business goals.Q:

Extending VBA Macro

I am working on a macro that is supposed to check the date of birth and then the date of death in an excel file.

I have written a macro that checks if the date of birth is older than the date of death. If it is older than the date of death, it changes the cell value to “Yes”. If it is not older than the date of death, it changes the cell value to “No”.

Now, I want to extend this macro to check if the date of death is older than the date of birth. If it is older than the date of birth, it changes the cell value to “Yes”. If it is not older than the date of birth, it changes the cell value to “No”.

I want to extend this macro to check if the date of death is older than the date of birth. If it is older than the date of birth, it changes the cell value to “Yes”.

Formerly, it was not possible to extend a macro to check if the date of death is older than the date of birth.

I am not sure if I am doing it right. I am attaching the code that I have written. Please let me know if I am doing it right or not.

I want to extend this macro to check if the date of death is older than the date of birth. If it is older than the date of birth, it changes the cell value to “Yes”. Formerly, it was not possible to extend a macro to check if the date of death is older than the date of birth.

I am not sure if I am doing it right. I am attaching the code that I have written. Please let me know if I am doing it right or not.

You are doing it right.

What you need to do is add the “On Error Resume Next” at the beginning of your code. Then if the “On Error Resume Next” does not work, the code will not execute.

It is a common practice to use “On Error Resume Next” to help catch errors in the code. This will allow you to continue running the code and not have an error thrown.

Leave a Comment

Your email address will not be published.