Blank cells added to database

[tapsmiled]

I have the following code which updates a database. I would like to ensure that when the user hits the SUBMIT button they are not accidentally adding blank information to the database. Basically, if there is no name entered, I would like the user to receive an error and not be permitted to add empty values to the database.

Please Login or Register  to view this content.

[Kaper]

may be:

Please Login or Register  to view this content.

[tapsmiled]

I tried it. It did give me the pop-up box, but it still added an empty row on the DATABASE sheet

[Leith Ross]

Hello tapsmiled,

This will display a message to the user then exit the macro leaving the Text Boxes as they were.

Please Login or Register  to view this content.

[Kaper]

Hi tapsmiled,

Can't be true.
If condition is met, only msgbox pops out and then everything between else and end if is skipped.

[tapsmiled]

Hello tapsmiled,

This will display a message to the user then exit the macro leaving the Text Boxes as they were.

Please Login or Register  to view this content.

Worked perfectly. Thank you!!!

[tapsmiled]

Hi tapsmiled,

Can't be true.
If condition is met, only msgbox pops out and then everything between else and end if is skipped.

Somehow it only populated the comma that appears between Last Name and First Name. I did get it to work, though, with the above formula. Thank you anyway for your assistance!!

[Kaper]

OK. Let me dig a bit deeper, because I love to learn from such cases. The longer I deal with it, the more obvious to me is that I am still on the steep part of Excel (and especially VBA) learning curve.

In my eyes, the only difference is that:

Please Login or Register  to view this content.

checks only firstname and lastname for beeing empty
while

Please Login or Register  to view this content.

checks if any of: lastname, firstname, CCN and date of hire is empty (has len=0)

the rest, I mean this:

Please Login or Register  to view this content.

and this:

Please Login or Register  to view this content.

are equivalent.

So if someone (Leith Ross?) could explain why one works and other not, I'd appreciate.

Of course, I'm glad that at least one suggestion helped with the main problem of the thread.

[Leith Ross]

Hello Kaper,

In the future, please do not post a new question in existing thread . Please start a new thread and include the URL or a link to the post you have a question about.

Please Login or Register  to view this content.

The code above validates that first name and last name are not empty (zero length strings) and they are not just spaces. The Trim function removes leading and trailing spaces from the string.

Which one is not working for you?

[Kaper]

For me both solutions work. But for tapsmiled mine did not, because (thanks for explaining this) the textbox(es) was(ere) not really empty but contained for instance a space (still looked as blank ones).

Probably this observation:

It did give me the pop-up box

was for one case (really empty) and this:

but it still added an empty row

for (not really empty - just looking empty).