Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface.
Table of contents
VB (Visual Basic) is a Windows application. It is a programming language, more precisely a modern object-oriented BASIC, which makes it possible to write autonomous applications, that is to say "double clickable". There is currently no version (November 2002) of Visual Basic for Macintosh, and to my knowledge, this is not the order of the day.
VBA (Visual Basic for Applications) is a subset of VB, integrated with Microsoft Office applications. VBA is less powerful than VB (no stand-alone application possible), but has the features of the associated application (Excel, Access, Word, Powerpoint, ...).
Although VB only exists for Windows, VBA is happily present in Office versions for the Macintosh.
To use VBA, you have to leave Excel in a certain way: VBA has an interface of its own, with its menus, preferences and toolbars.
It should be understood that opening Excel gives access to 2 separate software, all 2 capable of interacting with Excel objects. The first is Excel itself, the second is VBA, of course.
The existence of 2 applications is crystal clear in Windows because they appear clearly in the taskbar.
Understanding the following requires functional knowledge of Excel.
You will be able to improve your knowledge of this software by reading the content of sections on Excel 2003 and Excel 2007.
Size : | 878.189 Kb |
File type : | |
Downloads: | 1588 |
Created: | 2018-05-23 |
Introduction to VBA in Excel - PDF Tutorial
VBA Excel 2010, 2013 and 2016 Tutorial in PDF
Learning access-vba PDF course
How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...
Full list of Excel functionsDownload the complete list.of Microsoft Excel functions, free training document in pdf....
Quick guide to Microsoft Excel 2016Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....
Microsoft PowerPoint 2007This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....
VBA API TutorialDownload VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF....
The Beginner’s Guide to Microsoft ExcelThis is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...
Microsoft Excel 2013 courseDownload free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....
Quick guide to PowerPoint 2010This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....
Introduction to Microsoft Word 2013This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....
Tutorial Access 2016 in PDFDownload free Tutorial in PDF about Microsoft Access 2016 (course, exams and exercises), a complet training document course on 322 pages for beginners by MARY LEMONS....