Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft excel

Microsoft excel

ResolvedVersion 2003

Wed 20 May 2009, 17:01 Delegate Anthony said...

Anthony has attended:
Excel Intermediate course
Excel Advanced course

Microsoft excel

is it possible to edit the visual basic programming that lies behind excel functions ?

Thu 21 May 2009, 14:09 Trainer Amanda said...

RE: microsoft excel

Hello Anthony

Thank you for your question.

You can use the Visual Basic Editor to create your own custom functions (i.e. additional functions besides those available ordinarily in Excel), however it can't be used to edit functions that come built into Excel.

Kind regards
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Microsoft excel

Microsoft excel

RE: microsoft excel

Excel articles

Excel tip:

Bracketed negative numbers