PC Review


Reply
Thread Tools Rate Thread

Displaying Line Number In VBA Code

 
 
Sheldon Potolsky
Guest
Posts: n/a
 
      5th Nov 2009
While viewing VBA code, I used to be able to see the line # where the
cursor was, displayed toward the top of the screen. I noticed today
that I no longer see the line number and have been unable to figure
out how to get it to display again. Can someone help?

Thanks, Sheldon
 
Reply With Quote
 
 
 
 
Rick Rothstein
Guest
Posts: n/a
 
      5th Nov 2009
Check to make sure you are displaying the Standard Toolbar. Click
View/Toolbars from the VB Editor menu bar (or simply right-click the menu
bar itself) and look to see if Standard has a checkmark next to it. If not,
click that item. If, on the other hand, it is checked, then try clicking the
Customize option at the bottom of the panel, select the Standard item in the
list that appears and click the Reset button... that should restore the
Standard toolbar if it was corrupted in some way.

--
Rick (MVP - Excel)


"Sheldon Potolsky" <(E-Mail Removed)> wrote in message
news:13afa6cc-fe56-4c24-b0a2-(E-Mail Removed)...
> While viewing VBA code, I used to be able to see the line # where the
> cursor was, displayed toward the top of the screen. I noticed today
> that I no longer see the line number and have been unable to figure
> out how to get it to display again. Can someone help?
>
> Thanks, Sheldon


 
Reply With Quote
 
Sheldon Potolsky
Guest
Posts: n/a
 
      5th Nov 2009
On Nov 5, 1:29*pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> Check to make sure you are displaying the Standard Toolbar. Click
> View/Toolbars from the VB Editor menu bar (or simply right-click the menu
> bar itself) and look to see if Standard has a checkmark next to it. If not,
> click that item. If, on the other hand, it is checked, then try clicking the
> Customize option at the bottom of the panel, select the Standard item in the
> list that appears and click the Reset button... that should restore the
> Standard toolbar if it was corrupted in some way.
>
> --
> Rick (MVP - Excel)
>
> "Sheldon Potolsky" <SHPsalm...@aol.com> wrote in message
>
> news:13afa6cc-fe56-4c24-b0a2-(E-Mail Removed)...
>
>
>
> > While viewing VBA code, I used to be able to see the line # where the
> > cursor was, displayed toward the top of the screen. *I noticed today
> > that I no longer see the line number and have been unable to figure
> > out how to get it to display again. *Can someone help?

>
> > Thanks, Sheldon- Hide quoted text -

>
> - Show quoted text -


Thanks Rick. View/Toolbars/Standard was already checked AND so was
View/Toolbars/Edit. I unchecked Edit and the upper-middle area of the
screen now shows Line and Column again. Thank you.

Sheldon Potolsky
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying the line of code that caused the error David9746 Microsoft Access 4 29th Aug 2008 05:01 AM
vba code line number kdp145 Microsoft Excel Programming 3 7th Jul 2006 03:12 PM
Code Line Number in VBA =?Utf-8?B?TWFzb3Vk?= Microsoft Excel Programming 2 1st Feb 2005 01:54 AM
code line number =?Utf-8?B?TWFzb3Vk?= Microsoft Excel Programming 3 31st Jan 2005 07:50 PM
How to get the code line number? RA Microsoft C# .NET 2 13th Jan 2004 05:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 AM.