excel 2003 training course - 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 2003 training course - VBA

excel 2003 training course - VBA

resolvedResolved · Low Priority · Version Standard

replyReply Fri 1 Feb 2008, 16:41Delegate Ashpal said...

Ashpal has attended:
Excel Intermediate course
Excel Advanced course

VBA

Is it possible to manipulate macros recorded in Excel in VBA?

For upcoming training course dates see: Pricing & availability

replyReply Sun 10 Feb 2008, 11:53Trainer Stephen said...

RE: VBA

Hi Ashpal,

Thankyou for your question.

It is indeed possible.

If you press ALT-F11 you will open the VBE, which is the environment in which you can write code

Your macro will be stored in a module, and once located you can then modify any aspect of it that you require.

Note however if you are going to make major changes then it is often better to write the thing from scratch than recording it.

Regards

Stephen

 


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