Macro Basic: "If" statement problem or is it the &

[Guest]

I am getting a syntax error when I use a cascading IF, but as far as I can ascertain (from the Help and Sun's Basic Programming manual) this should at least run (I'm not sure about the logic of what I am trying to achieve!):

if (charCount > 0) and (len(numberToRemoveAsString)= 1) then outputString = left(inputString, charCount - len(numberToRemoveAsString) - 1 ) + right(inputString, len(inputString)-charCount)
oSelection.String = outputString
else if resultofand = -1 then outputString = left(inputString, charCount - 2 ) + right(inputString, len(inputString)- charCount)
oSelection.String = outputString
else MsgBox "That number is not present"
end if

This produces an error at the elseif: "else/elseif without if"
Also, I have to click the OK button twice to dismiss this message.
I have another version of this which does not produce a syntax error but also does not produce the correct results - the actual logic of the processing of the IFs is not what I would expect. It seems that only the first test is done, if that fails the macro continues after the "endif" and ignores the "elseif".
Why do none of the help examples include more than one line of code to be executed after an "if" or "elseif"

[JohnV]

See if this works for you:

[Guest]

Thanks John V - that at least solved the syntax error and probably explained why I thought the "if" command did not work as expected. I feel really stupid but in my defence I have used languages that don't mind where you put the rest of the "then". Do you think there is a case to be made for the manual/help page to mention explicitly that the "then" statements should begin on a separate line?
Thanks again from the other side of the Atlantic.

[JohnV]

Didn't Will Rogers say something like, "I never met a language that didn't have its syntax quirks."?

You can get away with continuing "then" on the same line if you use a colon or if you have a one line "If" statement.

[Guest]

Can't comment on Will Rogers - he's no that well known over here. Back on subject, how did you find out that you can continue "then" on the same line. I didn't see it in the Sun manual. Is it a guess from using a different language or is there more/better documentation out there?

[pitonyak]

I found a log of things that are not documented. Some of them I found by reading the source code, some I found by looking at other examples, and some I found because it worked in VB, I tried it in OOo, and it worked.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

[JohnV]