Problem with Message Prompts

Hi,

I have the following code and the message prompts aren't cooperating the way I need them to. Basically, the code looks at 3 different cells one at a time to check if they are blank or not and provides a message to the user if it finds any that are blank and then exits before creating a new record. The problem I'm having with it is with the 3rd cell (D6) being blank and no message popping up AND that if all three cells (B6 through D6) contain a value, it isn't continuing to create a new record. ?? Can anyone see where I'm making a mistake? Thanks for your help!

Please Login or Register  to view this content.

I didn't look closely at your code's logic, but be aware that if you have a cell with a formula that returns "" (an empty string but still a string), the IsEmpty function will return a False on that cell. That cell is not considered to be empty by IsEmpty.

You could test a formula-cell that returns a "" with...
If Cell.Value = "" then

Do you have formulas that may return "" in any of the three different cells ?

stnkynts, thanks very much for your reply! Works exactly how I was trying to make it. And so much more elegant than my attempt.

AlphaFrog, thank you as well. I'm slowly trying to learn VBA... I sometimes end up looking for and find something similar to what I need and then try to manipulate it to my ends. Usually I'm able to figure it out just by reading many helpful threads on this site and others but I'm not really to a point yet where I can write my own full code. Thanks for your help.