Visual Basic Express
Visual Basic Express is a fast and easy way to create programs for Microsoft Windows. Even if you are new to Windows programming, with Visual Basic you have a complete set of tools to simplify development.
Microsoft Excel VBA
Build more powerful & robust spreadsheets, reduce user input mistakes and automate routine tasks – customise Excel to become just the way you need it to be
Microsoft Access VBA
Design a comprehensive database application with a complete interface coded to deliver an integrated solution to users
Microsoft Word VBA
Yes, even the humble word processor can be boosted with custom Visual Basic for Applications sub and function procedures. The most powerful uses are when integrating with data sources in Access or Excel
Our Visual Basic Course Consultants have the strongest reputation for training delivery AND practical experience in the real world writing code.
The main advantage of instructor-led classroom training courses is the interaction attendees have with the tutor.
Our trainers relish the prospect of challenging classroom questions; its what makes every day different, keeps us on our feet and helps us learn a thing or two as well.
Our ability to call on our practical coding experiences enables us to provide real-life scenarios. It means we can react to even the most random question and offer a range of solutions
Range Objects in Word VBA A common task when using Visual Basic is to specify an area in a document and then do something with it, such as insert text or apply formatting. For example, a macro may need to locate a word or phrase within a portion of a document. The portion of the[…]
Working With Excel Macro Security When you open a workbook in Excel, a security warning bar might appear above the worksheet, telling you that macros have been disabled. Unfortunately, the security bar blends into the Ribbon a little too well, and if you’ve created the workbook for someone else, they might not even notice the[…]
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[…]
VBA and System Information VBA provides almost no native support for operations involving system information; because Windows itself provides easy-to-call API functions for determining and controlling the environment, VBA doesn’t have to duplicate that functionality. Of course, some of the API functions are tricky to call, and information you need is scattered throughout the Windows[…]
Our instructor-led hands-on training courses are designed to help attendees learn new Visual Basic programming skills in Microsoft Office suite of applications. By the end of each course you will be confident enough to create procedures and controls for controlling the behaviour and appearance of objects in the relevant software application, create procedures that run[…]