VBA Project Sheet: ln39, col2 1

[WaterSprite]

On the toolbar of the VBA project sheet, there is a box that lists the line number and column of each individual letter of code. Is it possible to use that line number in code, as an example:

[Select Case aaaa2]
[Case VbNo]
[If aaaa2 = VbNo Then Resume ln39, col2]

 

[Andrzejek]

.... then you add a few lines of comments in your code in lines 20 to 27

Then what?

Have fun.

---- Andy

 

[SkipVought]

hi,

What is aaaa2?

Also the ln/col (a feature that I quite frankly have ignored and will continue to ignore) is merely a location help feature in the editor. It has absolutely nothing to do with the code.

The better coders use a structured code technique that eliminates the use of Goto a lineNumber. Using the GoSub...Resume statement structure is probably the only departure, but the Resume implies the next statement after the GoSub.

Your code...

Select Case aaaa2
  Case VbNo
    'this will execute when aaaa2 EQUALS vbNo, no IF required!!!
End Select

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[WaterSprite]

Skip, thanks for the lesson. I have used ln/col as a locate feature, just wondered if it did anything else. Now I know.