Code error in blank text boxes checking and saving in user form

Dear Members,

I am using user form to collect data and save to worksheet.

Following error is coming:

a) My vba Code not checking entire blank text boxes

b) When any textbox is having data, code stopping there, even blank text boxes present after that data textbox, code is not checking that part

Example:

i) If first textbox in user form having data, my code is stopping there, even if next textbox is blank, it is not checking that part

ii) Code is executing until it founds, data in textbox, if it found data in a text box, it is stopping there, not going further text boxes


c) Before saving user form, it is not checking entire user form for blank text boxes. It is only checking first text box, if it is blank otherwise

d) If first text box is having data, code not checking any blank text boxes and saving the data


Any help in this regard is greatly appreciated

Thank you
Jwala

I am uploading the file for your reference


Using the following vba code:

Please Login or Register  to view this content.

Hi,

The reason you're having the issue is how you've set up your IF statements. The following Code segment contains your IF statements (I removed some of the text to remove clutter, since it's the IF statement layout I'm trying to emphasize):

Please Login or Register  to view this content.

When your first IF statement is FALSE -- that is, Trim(Me.txcustname.Value) <> "" -- then all the rest of the inner code doesn't get executed. That's how nested IF statements work (which is what you're doing)

At the end of your if statements, you have a whole bunch of End Ifs, one for each of your preceeding IF statements.

The layout I'd recommend is this (note the End Ifs are in different places):

Please Login or Register  to view this content.

S

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save