using end if inside an if loop

[smakatura]

my code looks like this so far


legend for coding/question below

• newvariable is the variable name for an inputted value
• ...A actions -the commands if the value is A
• ...X actions - commands if the value is not A or B

if newvariable = "A" then
     ....A Actions
else 
     .....X Actions
End if

I want to add a B value. if the value is B, I want it to do nothing - end the loop and move on with the macro...so something like

if newvariable = "A" then
    ....A Actions
else if newvariable = "B" then
    endif
else 
    .....X Actions
End if

I think the first endif is probaby the wrong way to do it.

Essentally I can have 6 values- A, B, and X (where is X anything but A or B) . If A, do the A actions. If B, I want to exit the loop. If anything but A or B do the X actions.

what is the proper coding?

 

[VoG]

Instead of endif try Exit For

 

[smakatura]

will "exit for" work within the if-endif statement?

I am not sure if something like "resume next" would be the right action.

 

[MAP1168]

You could try something like this.
Not sure how many X actions you have. But the loop ends when newvariable="B"
note "the value of # is the number you have given to your subroutine"

Sub Main#()

do until newvariable ="B"
if newvariable="A"
then
..."A" actions
else
...."X" actions
endif
Loop

endsub

 

[smakatura]

bc I could not find the right wording for ending the loop with in the if statemetn, I went with the code below, it worked great

if newvalue <> "B" then   
  if newvariable = "A" then
     ....A Actions
  else 
     .....X Actions
  End if
End if