Monday, June 18, 2012

Programming Skills: Some good sites to explore and learn VBA - Excel, Word, Outlook, Access & PowerPoint

Microsoft Office programming skills


Microsoft Office Programming Skills


Microsoft Office applications such as Word, Excel, PowerPoint, Outlook and Access can be controlled in several aspects of user interface (UI) including menus and toolbars. Looking at the benefits of VBA which doesn’t need any additional software to be installed other than Microsoft Office, many will definitely agree to learn it. It doesn’t matter if you are new to VBA or have any basic programming knowledge, once you start, it will be a lot easier.

Technically, in brief, Visual Basic for Applications (VBA) is closely related to Microsoft Visual Basic 6.0 programming language. Through VBA, Microsoft Office applications features can be customized and automated. Like Visual Basic 6.0, VBA is also event-driven and references Visual Basic Runtime Library. Using Windows API functions and dynamic-link libraries (DLLs), VBA programmer can create their own functionalities within Office applications. OLE Automation allows VBA to interact from within one Office application to other.

You can find some good sites online which provide free VBA tutorials along with good examples. You can start with Office application you use most. For e.g. VBA for Microsoft Excel and then later on others. You can refer below mentioned sites which looks to be good source for learning VBA.

Microsoft Excel VBA learning sites:



Microsoft Word VBA learning sites:



Microsoft Outlook VBA learning sites:



Microsoft Access VBA learning sites:



Microsoft PowerPoint VBA learning sites:


2 comments:

Popular Posts