Functions

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

Resolved · Low Priority · Version 2003

Functions

Jana has attended:
Excel VBA course

by - delegate Jana [1 post] (2008 May 8 Thu, 16:40) Reply

if i create a function, can i assign it an icon on teh toolbar?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: functions

by - trainer Tracy platinum contributer [586 posts] (2008 May 12 Mon, 01:02) Reply

You can assign it to a toolbar. Just create your function and name it, then go to Customise and right click over your button and assign a Macro (or function). Good luck
Tracy

· Microsoft Excel's Best Kept Secret
· Crazy Things People Have Done With Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part One
· Do You Really Need Excel VBA Training?

Please browse our web site to find out more about
excel vba training course london 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