Help with a VBA condition

[DonJuan85]

Hi

I have this VBA code but I would like it to not produce an error message if the TextBox is left blank.

Please Login or Register  to view this content.

Thanks

Don

[LJMetzger]

Hi Don and Welcome to ExcelForum,

Try the following (changes in red):

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I answered your question because this is your first post.

Lewis

[DonJuan85]

Thank you. I was unaware of this or how to do it.

Noted.

Thanks

Don.

[DonJuan85]

Unfortunately I get the error..

Compile error:

Block If End If

[skywriter]

Unfortunately I get the error..

Compile error:

Block If End If

Make sure the line below the one in red matches also. He changed that from a plain If statement to an ElseIf, this could be the issue.

[DonJuan85]

Perfect, thanks.

Also - A bit off topic but do you know how I can create a command button to go to the next tab on a MultiPage user Form? It is the code I am struggling with as I cannot reference the tab for some reason.

Thanks

[LJMetzger]

Thanks Sky. See the additional red in my post above. Sorry for the misunderstanding.

Lewis

[DonJuan85]

That's OK. Do you have an answer for the question above?

Thanks

[LJMetzger]

Don,

Cut and paste the entire macro above. There was an 'Else' that previously not red, that you probably omitted.

[DonJuan85]

Hi

I meant the question about how I can create a command button to go to the next tab on a MultiPage user Form? It is the code I am struggling with as I cannot reference the tab for some reason.

[skywriter]

Also - A bit off topic but do you know how I can create a command button to go to the next tab on a MultiPage user Form?

You should probably just start a new thread.

[DonJuan85]

Thanks. Already have.