Eident Scotland IT Training Skills

Custom Functions in Excel VBA

You can write Visual Basic For Applications (VBA) code to create your own custom functions in Excel VBA, known as Used Defined Functions. Working With User‑Defined Functions Although Excel includes many built‑in functions, you will often need to create your own user‑defined functions to perform calculations for which no Excel function exists. For example, you[…]

Microsoft Word Fields Quick Parts

Microsoft Word Fields

What are Microsoft Word Fields? Microsoft Word Fields are used as placeholders for data that might change in a document and for creating form letters and labels in mail-merge documents. Microsoft Word inserts relevant fields automatically at certain times.  For example, when a table of contents is created by using the References -> Tables of[…]

Visual Basic Training

Tips for Microsoft Word VBA Macros – from Eident Training

The Basics of VBA You can automate many routine tasks with Microsoft Word VBA Macros (actually, Macros are Visual Basic Sub Procedures; there are also Visual Basic Function Procedures). Microsoft Office applications, such as Word, Excel, PowerPoint, Outlook, Access and Project share a common programming language called Visual Basic for Applications (VBA).  VBA is an[…]

Microsoft Excel Training Course at Eident

Training Course Discounts

At Eident we offer substantial discounts to multiple attendees booked on any of our standard public training courses.  For every additional attendee an organisation sends on one of our training courses in Glasgow or Edinburgh the percentage discount increases. Discounts from 25% to 85% apply for multiple bookings on the same course. For example, for[…]

Excel Developer

Microsoft Excel VBA Function Procedures

User-Defined Functions Microsoft Excel VBA Function Procedures can be used to standardise and simplify any type of calculation in Excel spreadsheets. As a user of Excel you will be aware that the application already comes with a vast library of functions. In Excel, whether you use a simple SUM() function or a more advanced one,[…]

Microsoft Visual Basic

Some Visual Basic Programming Design Standards

Visual Basic Programming Design Standards Visual Basic Programming Design Standards for coding aren’t about rules that have been set in stone, they’re about practical guidelines that in the end will make your life as a programmer easier and your programs better. The intent in presenting this content isn’t to hand down a set of programming[…]

Microsoft Office

Top Ten Tips To Speed Up Your VBA Code

1. Turn off Screen Updating This will stop the screen flickering and updating while executing or running macros, and that will greatly speed up your code. Sub Stop_ScreenUpdating () Application.ScreenUpdating = False ‘… (Your Code) Application.ScreenUpdating = True End Sub Tip: Use Application.ScreenUpdating = False at the beginning of your code and Application.ScreenUpdating = True[…]