Dont Allow Empty Userform Fields

[Adam Hewitt]

I have a userform and i need to make sure that when the user presses the add client button, it only adds the info from the userform to the sheet if all fields are filled.

The code that i have at the minute doesnt allow you to proceed if a phone number has been added but i dont know how to make it work for multiple fields.

Please Login or Register  to view this content.

Any help will be greatly appreciated

[snb]

Why is the 'add client' button visible if not all compulsory textboxes have been filled ?

[Domski]

Something like this:

Please Login or Register  to view this content.

Dom

[royUK]

Here's an example to adapt

[Adam Hewitt]

The reason that the button is available, is that i dont know how to make it not available when all the fileds are not filled.

[Adam Hewitt]

Here's an example to adapt

I dont think that this is right for me.

The code that i have works but only for one field. I dont know how to make it work for multiple fields.

[Adam Hewitt]

Something like this:

Please Login or Register  to view this content.

Dom

I dont think that will work as it needs to be told to look at all the fields before allowing the sheet to be populated.

[Domski]

Mine was just an example and could be extended for as many fields as required.

snb's suggestion is a good one to only make the button available once the fields are completed. I'm sure he'll provide you with an example of how to achieve this if you want.

I'm off home now.

Dom

[snb]

Please Login or Register  to view this content.

[royUK]

I dont think that this is right for me.

The code that i have works but only for one field. I dont know how to make it work for multiple fields.

Why it loops through controls & checks if they are complete. You can set the CommandButton's Visible or preferably Enabled Property according to the Function results

[romperstomper]

Personally I would just loop through all the textboxes and check them before proceeding; if you want to disable the button instead, I would use its enabled property rather than have it suddenly appear or disappear.

[Adam Hewitt]

i have tried the else if code that domski suggested and it just falls over and the debugger launches.

I want it to look through all the fields and make sure that they are filled. if i could get the add button to appear when all the fields have been filed then that would be great but i dont know how to do that. As i am very new to this and quite basic at the minute any code that is posted, i would appreciate it if what the code is doing is explained.

The best way that i can see this being achieved is if the code on the add button is looking through all the fields and if one of the fields is empty then do not allow the information to be added to the sheet. I would like the message box to say, for example, "please enter an email address and phone number".

I want all empty fields to be named in the error message.

[romperstomper]

Dom's code should work if you added it correctly, but it would be simpler to loop through all textboxes as snb did.

[snb]

I want tot warn all helpers:

After 3 posts in this forum Adam Hewitt found it necessary to denunciate my question (that contained a solution implicitly) by a distraction to my reputation, adding 'Doesnt help answer the question'.
I categorize this guy in the group of the 'too shortly fused'.
Look for instance how gently he denounces other solutions.

[royUK]

Adam

Giving negative rep because you either don't understand a solution is no way to get help.

I've reversed the rep

You seem to have an idea of what you need to do, but won't check suggestions that differ slightly.