Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA general

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA general

Resolved · Medium Priority · Version 2003

Reply Fri 2 Jan 2009, 15:41Delegate Nikolas said...

Nikolas has attended:
Excel VBA Intro Intermediate course

VBA general

Can you send me Microsoft's VBA manual. I have heard that is 300 pages long , I guess you must have a digital copy of that document so you can sent to your clients.

Im hoping that this document will have somethign along these lines.

activeworkbook
.activate ''activates the sheet
.worksheets ''refers to the worksheets object
.add '' adds a sheet
.select '''select/activate a sheet

I.E. a nice layout of the objects and their methods properties and what they do.

If you know the existence of such document please attach along with the VBA manual.

Many thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 21 Jan 2009, 14:44Trainer Amanda said...

RE: VBA general

Hello Nikolas

Thank you for your post.

As a delegate, you will be able to download reference material relating to the course you have attended with us by logging into your delegate account via our web site.

We do not have an electronic copy of the Microsoft VBA manual you refer to. We are not affliated with Microsoft directly, therefore we produce and distribute our own reference material.

Kind regards
Amanda

Reply Wed 28 Jan 2009, 21:00Delegate Nikolas said...

RE: VBA general

thank you for the reply.

after spending 10 or more minutes trying to find the link that will lead me to reference matterial/articles etc I gave up.

Can you send me the link where i can go and retrieve these files?

appreciate ur help on this.

Regards

Nik

Reply Thu 29 Jan 2009, 10:13Trainer Amanda said...

RE: VBA general

Hello Nik

I've checked with our VBA trainers and they are currently updating the manual, therefore I will send you a link once this has been completed - I expect this will be by the end of next week at the very latest.

Kind regards
Amanda

Reply Thu 12 Mar 2009, 11:02Delegate Nikolas said...

RE: VBA general

can you please resend the link. most likely i didnt received ur email.

many thanks

Nik

Reply Thu 12 Mar 2009, 11:08Trainer Amanda said...

RE: VBA general

Hello Nik

Thanks for your message, apologies, I forgot to send the link to you. Please find below:

http://www.microsofttraining.net/download/delegate/onsite/excel_vba_739422.zip

Kind regards
Amanda

Wed 4 Feb 2009: Automatically marked as resolved.

Excel articles

· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Prepare for your MOS Certification with MS Excel Courses
· How to start using Excel 2007 Functions
· Where Are The Form Controls In Different Versions Of Excel
· Create Contrasting Coloured Rows In Excel

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

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips