stop a procedure

[joemo2003]

In excel VBA.
For example,

If cells(i,1)=1 Then
  Call Procedure1
  Call Procedure2
End If
If ....
  ...
End If
Loop

The Procedure1 and 2 will execute every loop, but I only want the Procedure1 excutes once, and the procedure2 excutes everyloop. How can I do that?
thanks

[Killer42]

Probably the simplest way is to create a variable which you use to "flag" the fact procedure 1 has been run. Each time 'round the loop, if the flag hasn't been set, then run procedure 1 and set the flag.

[joemo2003]

Probably the simplest way is to create a variable which you use to "flag" the fact procedure 1 has been run. Each time 'round the loop, if the flag hasn't been set, then run procedure 1 and set the flag.

what is flag? I try to figure out "Flag" a long time ago, but still can't.

[Killer42]

what is flag? I try to figure out "Flag" a long time ago, but still can't.

The term "flag" just refers to a variable that you use to indicate a particular situation. In this case, a boolean variable that you would set to True to indicate that you have performed the thing you only want to do once.

Here's some pseudo-code showing a general example (based on your situation) of the way a flag might be used...

Clear flag (set to False)
Start loop
  If Flag is not set Then
    Do Proc1
    Set flag (set value to True)
  End If
  Do Proc2
End Loop

[joemo2003]

The term "flag" just refers to a variable that you use to indicate a particular situation. In this case, a boolean variable that you would set to True to indicate that you have performed the thing you only want to do once.

Here's some pseudo-code showing a general example (based on your situation) of the way a flag might be used...

Clear flag (set to False)
Start loop
  If Flag is not set Then
    Do Proc1
    Set flag (set value to True)
  End If
  Do Proc2
End Loop

great, thanks