if statement help

[birdman]

does anyone know the code that if an if statement is true then go back to a certain point in the code and start from there again?

 

[Norie]

Steve

Why not use a loop?

 

[gingerafro]

I'm a bit confused.
I assume that you are wanting to do the IF statement again but with a different value or different cell etc. (If you kept using the same value, which returns true, then you'll have a never ending argument!)

If I'm right, then I guess you are after a looping macro. Tell us what you are after and we'll be in a better position to help.

 

[MichaelRo]

Look at the Goto Statements in the Help Function

ie

StartAgain:

If YourValue = True Then GoTo StartAgain

 

[birdman]

i have a userform that has a section to select one or more text files to be analyzed using a listbox. on the same userform, the user can select a number of checkboxes. these checkboxes are connected to operations that can be performed on the text files.

so if you select 2 text files and a few of the checkboxes, the first text file is opened and analyzed, then the second file is opened and analyzed. this is done using a for loop

i am now attempting to incorporate a text file splitter into my program (in case the text file is over 32000 rows - the max for graphing). after the file is split into 2 separate workbooks, the second half is closed, and the first half is analyzed. then i need the second half to be opened again and analyzed.

i can get the first half to be analyzed, but once that is done i need to open the second half and go back to a certain point in the for loop and continue the analysis from there before i move onto the next text file in my listbox. hope this makes sense.

thanks for the responses

 

[birdman]

thanks michael that is what i need. let me see if its going to work.

 

[HalfAce]

I agree with the answers provided so far. (Depending on what you're doing), a loop is likely the way to go. To answer your question though, the code might look something like this.

Sub Demo()
Dim SomeStuff
Dim SomeMoreStuff

Some code here

StartAgain:
  Some code here
  Some more code here
  If (my if statement) Then
    GoTo StartAgain
  Else
    Whatever you want if it's not true.
  End If
  
End Sub

A loop (if possible) is generally more preferred to using GoTo statements, especially several of them.

 

[birdman]

ended up working great. thanks guys.

 

[birdman]

for those of you who are interested. i used goto within a for loop. here is an example.

Dim test as Integer
If test = 0 Then
     'code here
     test = 1
     GoTo StartAgain
End If

StartAgain would be earlier in the for loop

although it is not recommended to use the goto command, it has worked good so far.

 

[HalfAce]

although it is not recommended to use the goto command, it has worked good so far.

I know some folks don't like to use GoTo at all, (and I guess if within reason you can avoid it you should), but when used sparingly I've never had a problem with them. (yet.)