Line Nos. in Visual Basic Editor

[apka]

Is there any way I can display line numbers against the code in the Visual Basic Editor?

Or can I see in the current line number in the status bar?

or GoTo Line number?

[shg]

The line and column of the cursor position are displayed on the menu bar at the top of the VBE window.

[apka]

I didn't find a tongue-biting icon here.. adjusting with a wink

Thanks!

[shg]

Does your scroll wheel work in the VBE?

[apka]

nope!
waiting for your answer..

[shg]

One of several such utilities available, and the one I use. Drove me crazy not being able to scroll.

http://www.geocities.com/SiliconVall...freewheel.html

[shg]

Some other options mentioned in http://www.ozgrid.com/forum/showthread.php?t=74916

[dominicb]

Hi guys

Does your scroll wheel work in the VBE?

This particular annoyance has been fixed in Excel 2007.
(just in case you didn't know).

DominicB

[NBVC]

The line and column of the cursor position are displayed on the menu bar at the top of the VBE window.

I don't see this in my VBE. Is there a way to toggle it on/off?

[dominicb]

Hi NBVC

I don't see this in my VBE. Is there a way to toggle it on/off?

Haven't you got nappies (oops, diapers) to change or something
It's part of the "Standard" toolbar - do you have this displayed?

HTH

DominicB

[VBA Noob]

NBVC,

See example

VBA Noob

[NBVC]

Hi guys,

I do have the Standard toolbar visible, but don't see the row/column identification as shown in VBA Noob's sample.

....must be something obvious I am missing?

EDIT: I attached a screen shot of my VBE

[NBVC]

...hmmm strange.....

I think I "fixed it". All I did was just moved the Standard Toolbar down and low and behold the line/column identifier showed up... and when I put the toolbar back, the identifier remained... so I guess it just needed to be "awoken" or something....

I never knew this feature existed...


Thanks guys.

[dartveiga]

I Just did It! Works great!

To add support for the scroll wheel to Visual Basic for Applications follow this

http://office.microsoft.com/en-us/ex...175901033.aspx

[sttjones]

I had the same problem in Excel. I searched for Excel Visual Basic Editor show line number.
Since the line and column are at the end of the default display of the toolbar window, it is the first thing to get cut off when another toolbar on the same line and too wide for both to fit in the monitor window.
I followed the advice and drug one toolbar down so each toolbar was on a separate line and the line and column display window appeared.
I had a difficult time finding an answer so I'm glad I came across this thread.
So the short answer is the line and column number is part of the default toolbar. Just customize one of the toolbars to make both totally fit in your display window.