visual basic

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Visual Basic

Visual Basic

resolvedResolved · Low Priority · Version 2003

Charmain has attended:
Excel Intermediate course
Excel Advanced course

Visual Basic

how do i get to the VB page

RE: Visual Basic

Dear Charmain

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


To get to the Visual Basic Editor window to modify the code or copy the macro from one work book to another you have to choose Tools > Macro > Visual Basic Editor. The Shortcut key for it is ALT+ F11.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 23 Mar 2009: Automatically marked as resolved.


 

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


Server loaded in 0.08 secs.