How not to have to use loats of End If's

[ndtsteve]

Every time I add another If command I have to add an End If at the end. Is there a way to avoid this?

Please Login or Register  to view this content.

[Pulsus]

ndtsteve,

You can use de "ElseIf" in your code.

Please Login or Register  to view this content.

[jraj1106]

Hi


Try this:

Please Login or Register  to view this content.

[Fettertiger]

Hi Steve,

not sure if the macro really does what you intended. The way how you structured it the second "if" would only be used if the first "if" was already fullfilled. I assume you would like to have it like this instead:

Please Login or Register  to view this content.

Regards

Theo

[Fettertiger]

jraj1106 was quicker :-) credits go to him

[ndtsteve]

I have tried using ElseIf but if I do that then the subroutine stops after the first MsgBox and does not go thu the rest of them. It runs thru them all if I just use the If's and EndIf's. I am just wondering if there is a 'neater' way to wtite the code.

Please Login or Register  to view this content.

[Fettertiger]

Steve,

you could do it like this, but it would mean your would activate a new sheet even though the actual issue is not solved.

Please Login or Register  to view this content.

Regards

theo

[ndtsteve]

Thanks Fettertiger (theo) that it a great help and now it steps thru the routine

[Pulsus]

ndtsteve,

Fettertiger is right, your macro should show the error to the user. You can use TextBox instead of MsgBox to user insert the value.

Pulsus

[StevenM]

Which structure you use depends on the logic needs of your program.

Please Login or Register  to view this content.