information sources
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 » Information sources

Information sources

resolvedResolved · Low Priority · Version 2007

replyReply Mon 22 Aug 2011, 16:37Delegate Anamaria said...

Anamaria has attended:
Excel VBA Intro Intermediate course

Information sources

is there any "best book" to use for quick references and use of VBA coding?

For upcoming training course dates see: Pricing & availability

replyReply Wed 24 Aug 2011, 09:31Trainer Mark said...

RE: information sources

Hello Anamaria,


Thank you for your question regarding books on vba.

My recommendation is a book called Master Visually Excel VBA 2003. They have never updated the manual, but all 2003 code is suitable for all versions including 2010.

The book can be picked up cheaply, and each page covers a separate command, so if you need to add a chart, or import data, or save multiple books etc.. code is described per page. Very clear.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Tue 30 Aug 2011: Automatically marked as resolved.

 

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

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

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