excel vba
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 Training and help » Excel 2007 - VBA

Excel 2007 - VBA

resolvedResolved · Low Priority · Version 2007

replyReply Thu 23 Apr 2009, 16:59Delegate Clare said...

Clare has attended:
Upgrade to Office 2007 course

Excel 2007 - VBA

How much has the VBA display changed in 2007?

For upcoming training course dates see: Pricing & availability

replyReply Fri 24 Apr 2009, 17:15Trainer Carlos said...

RE: Excel 2007 - VBA

Hi Clare

In Excel 2007 the Visual Basic Editor (VBE) looks exactly the same as in Excel 2003.

One change is that yuo can use the scroll button on the mouse to scroll up and down in the code window.

Hope this helps

Carlos

Fri 1 May 2009: Automatically marked as resolved.

 

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

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

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