Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Im a Little Confused
Amir Ouranus 
      
2 days ago
Hello everyone!
My apologizes if this is not the right place to post this; so here it goes.
What is the difference between Visual Basic and VBA.
Also, is there any difference between VBA for Access, Excel and Word?
Right now I'm taking the Access Developer classes; once I'm done with those can I write code for Excel and Word? Or are they different?
I would like to write code for any Microsoft product that can be programmed in VBA and or Visual Basic.
As usual any information about this would be greatly appreciated.
Kevin Robertson  @Reply  
          
2 days ago
Visual Basic and VBA are closely related, but they are not exactly the same thing.

VBA stands for Visual Basic for Applications. It is the programming language built into Microsoft Office applications such as Access, Excel, Word, Outlook, and others. VBA is mainly used to automate tasks, build forms, manipulate data, and extend the functionality of the host application.

Visual Basic (usually VB.NET these days) is a full standalone programming language used to create complete Windows applications, web applications, services, and more. VB.NET is part of the .NET framework and is much more powerful and modern than classic VBA, although the syntax is very similar.

As for VBA between Access, Excel, and Word:

    - The core VBA language itself is basically the same in all Office applications.
    - What changes is the *object model* for each application.

For example:

    - In Access you work with Forms, Reports, Recordsets, and databases.
    - In Excel you work with Worksheets, Workbooks, Cells, and Ranges.
    - In Word you work with Documents, Paragraphs, Bookmarks, and Tables.

So once you learn VBA in Access, you already know a huge part of VBA for Excel and Word. The biggest learning curve afterward is understanding the objects and features specific to each application.

Access is actually one of the best places to learn VBA because it uses a lot of real-world programming concepts like forms, events, automation, validation, SQL, and database logic. Many people who become strong VBA developers start in Access and then branch into Excel and other Office products later.

If your goal is to program Microsoft products in general, then learning Access VBA is an excellent foundation. After that, moving into Excel VBA, Word VBA, or even VB.NET will feel much easier because the syntax and programming concepts are very similar.
Add a Reply Upload an Image
Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/29/2026 4:33:58 PM. PLT: 1s