Can't edit ElseIf statement??

[bralew]

Hi All,

I have an ElseIf statement but cannot assign a secondary Else quality?

Please Login or Register  to view this content.

I basically want to add the condition if the above is not met then do nothing. Something like:

Please Login or Register  to view this content.

[PFDave]

stagger like this

Please Login or Register  to view this content.

[xlnitwit]

Simply

Please Login or Register  to view this content.

[bralew]

Get a problem with this.

[xlnitwit]

Yes, you have. I can see three End Ifs and not a single If statement.

[bralew]

Here it is in context, I just need it to switch off the warning: Driving me nuts<

Please Login or Register  to view this content.

[xlnitwit]

You seem to be testing the same things repeatedly, which serves no purpose. Also, you do the same thing twice to Textbox14. Perhaps this

Please Login or Register  to view this content.

[bralew]

Thanks, I'll give it a whirl. I do tend to test things more than once but I'm getting better at streamlining, Thank you

[bralew]

I'll pick this up in the morning, cheers

[bralew]

The code is much clearer thank you very much. However, I've got one error message that won't clear when it should. Can I upload an example, its too complex to explain.

[xlnitwit]

I think you'll have to.

[bralew]

Ok I'll send through now with a short description, thanks

[bralew]

Ok, here's some guidance:

Select = AXEGEN (this will open the userform)

From the drop down menu, complete the following detail:

CAPACITY = 1500KG
HUB = X
STUD/P.C.D. = 4/100
BRAKE TYPE = AUTO REVERSE
DROP ARM CENTRES = 127
OHF = 1375 (this has to entered manually)

At this point, TextBox14 will carry the message: "ERROR - INNER MEMBER COLLISION SEE TECHNICAL".

This basically means that the combined inner member length (which becomes inserted into the beam length) have collided in the middle.
The technical details in the bottom left corner show the length: 570 x 2 = 1140, 1140 - 62 = 1078mm
This 1078mm is higher than the beam length, at the top of 1064mm, hence the warning.

Now, we need to override this select a shorter inner member.

Select = INNER MEMBER L/H
Select = IMEM006

At this point another message will appear but ignore it

The combined inner member length is now 505mm (505 x 2 = 1064) - 1064 - 62 = 948

948 is well below the top beam length oc 1064mm.

Thus, the message in ComboBox14 should disappear as there is no longer a collision.

Hope this makes sense :-/

[xlnitwit]

I can't look at the file for the moment, but logically, you don't have anything to clear the warning box if Textbox7 is longer than three characters and none of your conditions are met. Perhaps you just need an Else clause

Please Login or Register  to view this content.

[bralew]

Ha! Ha!, thats's it! Thank you very much, your a genius!!