Previous article Next article
Excel Macros for the Non-Programmer
Wed 22nd August 2007
Even people who are experts at using Microsoft Excel don't often venture into the area of macros. Those that do are often satisfied with simple recorded macros and never look at the code that makes them work. "I'm an accountant not a programmer," is the common feeling.
Don't limit your Excel training. Excel VBA (Visual Basic for Applications), the language of macros, is a programming language that many non-programmers have embraced and become quite skilled at. Take a look at some of the features of this simple yet powerful language.
English-like syntaxWhen most people think of programming, they imagine lines like "Stack object [semi]attribute x18 flag set? Const x0119:x14". You won't see a statement like that in macro training. Excel VBA uses simple commands that are easy to read even if you don't know anything about programming. Consider the following example:
For each Employee in EmployeeList
Employee.Salary = Employee.Salary + 500
It doesn't take a computer science degree to guess that these statements give each employee a
Author is a freelance copywriter. For more information on Training excel VBA, please visit https://www.stl-training.co.uk
Original article appears here:
Back to article list
London's widest choice in
dates, venues, and prices
Buy now / Live dates
On-site / Closed company:
Office 365 End User
It's very useful, straight to the topic and the questions we asked. The best part was the practice because it makes the chances we understand and remember higher.
May be if desks in the room are organised differently the trainer would have had easier access to see what each attendee was doing individually.
Very good trainer, clear, precise and to the point.
Front Of House Manager
The course was very useful and has made me feel more confident about using excel
· Main client list