VBA

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[…]

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[…]

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,[…]

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[…]