Inserting a message box when no data is found and exit vba.

**BZ61** · 12-15-2024, 06:45 PM

Hello, I found a print vba code that works in my excel 365 sheet, but if someone hits the print button and there is no data in Column D the sheet locks up and has to be reset from the VBA Project. I've put the vba code below. I just need to know how to modify this code, so if there is no data in column D a message appears stating "No Data Found" then automatically exits the program without having to be reset. Thank you in advance for any assistance.

Please Login or Register  to view this content.

**6StringJazzer** · 12-15-2024, 06:56 PM

Find will raise an error if you try to refer to its row when nothing was found. Easiest thing is to trap the error.

Please Login or Register  to view this content.

**TMS** · 12-15-2024, 07:08 PM

Maybe this:

Please Login or Register  to view this content.

**BZ61** · 12-15-2024, 11:42 PM

You're suggestion worked perfect. Thank you.

**BZ61** · 12-15-2024, 11:50 PM

The suggestion from 6StringJazzer worked and I wanted to thank you for responding to my post. Thanks again.

**TMS** · 12-16-2024, 04:51 AM

You're welcome.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.