Excel VBA

Resolved · Low Priority · Version 2003

Excel VBA

Joy has attended:
Excel Advanced course
Excel VBA course

by - delegate Joy [8 posts] (2008 Aug 7 Thu, 16:27) Reply

how to run codes?

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: Excel VBA

by - trainer Carlos gold contributer [479 posts] (2008 Aug 8 Fri, 16:09) Reply

Hi Joy

The most common way to run code is to create Procedure (Macro) and then attach it to a button so as it runs everytime the button is clicked

Hope this helps

Regards

Carlos

· Crazy Things People Have Done With Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Tips for Transitioning to Excel 2007
· Training Budgets In A Bad Economy
· Tips to Facilitate Printing of Excel worksheets

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

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Rate this page: