INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I think the site is just incredible....I am learning more here than anywhere else before and am looking forward to being able to help someone .... this is my idea of what the Internet is supposed to do..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum

VBA Project Sheet: ln39, col2

Read More Threads Like This One

WaterSprite (TechnicalUser)

19 Jun 12 14:49

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 (Programmer)

19 Jun 12 14:57

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

Then what?

Have fun.

---- Andy

SkipVought (Programmer)

19 Jun 12 15:05

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...

CODE

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

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

WaterSprite (TechnicalUser)

19 Jun 12 20:12

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To VBA Visual Basic for Applications (Microsoft)