VBA Code to Check if a Range of cells is Empty or Not and run code accordingly

[unit285]

IFVBA.xlsm

I have a code here that finds a name in the database1 sheet and applies a payment, i have it matching the month as I want. Each Month is assigned 3 cells, for Pmt, Pmt Date, & Pmt Ref. What I need is to modify my code to check if any of the 3 cells are already populated and if so give a warning msgbox before entering the new payment info. If the 3 cells are all empty then no warning msgbox is needed and the new payment info can be entered as it is currently doing. All help is greatly appreciated!

[Bernie Deitrick]

This code will do what you want:

Please Login or Register  to view this content.

And should replace all this code:

Please Login or Register  to view this content.

[TMS]

Similar approach ...

Please Login or Register  to view this content.

Regards, TMS

[Bernie Deitrick]

Please Login or Register  to view this content.

[unit285]

This code will do what you want:

Please Login or Register  to view this content.

And should replace all this code:

Please Login or Register  to view this content.

Your consolidated code really made me feel the bern. and it works great. Thanks so much! I obviously have much to learn when it comes to vba

[TMS]

Is that a comment or a question?

[Bernie Deitrick]

It is a correction, in bold. You did not increment the column for the other two existing value checks.

[TMS]

Ah, thank you for that. The bold did not show up particularly well and I saw what I expected to see, not what you had tried to draw my attention to.

Thanks again. I will edit the post so that it is correct for anyone who tries to use it.

Regards, TMS

[Bernie Deitrick]

Sorry - I should have explained, too, with more than just bolding.

And thanks for the Rep, too.

[TMS]

@Bernie: you're welcome.