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 » VB and VBA

	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

VB and VBA

Resolved · Low Priority · Version 2007

Reply Fri 3 Apr 2009, 10:19Delegate Chris said...

Chris has attended:
Excel VBA Intro Intermediate course

VB and VBA

What is the difference between VB and VBA?

For upcoming training course dates see: Pricing & availability

Reply Fri 3 Apr 2009, 16:37Trainer Carlos said...

RE: VB and VBA

Hi Chris

Visual Basic (VB) is considered a full compilable programming language.

Visual Basic for Applications (VBA) has the same abilities normal Visual Basic except that VBA programs can not be compiled into Executable or DLL files.

VBA also doesn't run in its own memory space as a normal Visual Basic executables would.

Hope this helps

Carlos

Fri 10 Apr 2009: Automatically marked as resolved.

Excel articles

· Avoid Duplication In Excel By Ensuring Unique Values
· How To Create A Simple Currency Convertor In Excel 2010
· Want To Create A Presentation In Excel?
· How To Create A Macro In Excel 2010
· Baffled by custom number formatting in Excel?

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

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips