VBA Codings

The UK's most regular instructor-led training courses.
Training information: microsoft excel training · Excel course · VBA training UK

Resolved · Low Priority · Version 2003

VBA Codings

Adil has attended:
Excel VBA course

by - delegate Adil [1 post] (2008 Aug 14 Thu, 17:00) Reply

where do i get the codes from

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: VBA Codings

by - trainer Carlos gold contributer [479 posts] (2008 Sep 4 Thu, 10:39) Edited on 2008 Sep 4 Thu, 10:40 Reply

Hi Adil

Sorry for the delay in answering this question.

There are many places you can look up how VBA code is written.

The easiest one is Microsofts own Help section.

1. Open Excel

2. Select the Help menu and click Microsoft Excel Help or press F1

3. In the Excel Help task bar click Table of contents

4. in the list click Microsoft Excel Visual Basic Reference

Here you will find folders with examples of how each factor of Excel VBA works and examples of how to code them.

Hope this helps

Regards

Carlos

· Excel and Inventory Management
· How to Create Better Excel Spreadsheets: Part Two
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips

Rate this page: