Need help with 'Compile Error: Block If without End If'

[Kyhosa]

I don't know what happened, but my code was working, then I update a few textbox names and now I keep getting: 'Compile Error: Block If without End If'

I have gone through and added End If at the end of each If, but it still doesn't work, and I don't know what went wrong. It's more than likely something really easy, but I am having a difficult time figuring it out.

Maybe one of you will have better luck

Thank you in advance!

[Keebellah]

Hi probably here

Please Login or Register  to view this content.

And there are more errors

Please Login or Register  to view this content.

You have to place Me before the .

[Kyhosa]

It still isn't working, and I have tried multiple variations. I am only having issues when using the Submit Command button

[Keebellah]

I had hoped that with my minor correction a small light would burn to make you look through your code and fix the rest.
There are still a great number of Else and If that are incorrect.
Just that one section with all the Ifs and Else and incorrect If. take a better look.
VBA is perseverance, perspiration and time, a whole lot of it.
Give it a look and you''l see it works. I looked through it and made about 20+ corrections and it works here.
If you can't get it done, holler and I'll post it.
But this is the only way to learn

[Kyhosa]

I just went back through it all and fixed all the areas, and it now works!

[Keebellah]

Great, it’s all a question of patience
I also suggest that you review your code , you could reduce the lines of code by a lot if you avoid repetition and write common routines for the repetitive code you have

[Keebellah]

Add the following code to the userform code
Since your part number should always be numeric, this only allows numbers to be entered

Please Login or Register  to view this content.

This will also reduce the number of code lines

Please Login or Register  to view this content.

I also suggest you read this link so that you learn how to work with tables.
https://www.thespreadsheetguru.com/b...0with%20Tables