excel vba editor display
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA Editor display window

Excel VBA Editor display window

resolvedResolved · Medium Priority · Version 2010

replyReply Thu 17 Nov 2011, 14:11Delegate Shamin said...

Shamin has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel VBA Editor display window

Hi,

I am not sure what I had done but display wndow has become distorted and I cannot get the default window back with Project Explorer on left and Code on the right with Module etc bottom left.

How do I get the default display back? I searched on Google, no joy.

Kind regards
Shamim

For upcoming training course dates see: Pricing & availability

replyReply Fri 18 Nov 2011, 06:47Trainer Anthony said...

RE: Excel VBA Editor display window

Hi Shamin, thanks for your query. There is no default display, just the one you last saved. If you need to restore any of those windows, go to your View drop down men and activate the Project Explorer/Properties panel from there.

Hope this helps,

Anthony

replyReply Fri 18 Nov 2011, 09:21Delegate Shamin said...

RE: Excel VBA Editor display window

Ok, Anthony,

Thanks for the prompt reply. I will try that.

Regards
Shamim

 

Please browse our web site to find out more about
training ms excel advanced and other Microsoft training courses.

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard