Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2019, 06:24 AM
fransbosch fransbosch is offline How to learn VBA? Windows 10 How to learn VBA? Office 2013
Novice
How to learn VBA?
 
Join Date: Dec 2019
Location: Johannesburg, South Africa
Posts: 7
fransbosch is on a distinguished road
Default How to learn VBA?


Hello. I am new to this forum, but I am impressed so far.

I want to start using VBA, initially for Word. I have seen some useful threads in this forum, but the programming language is still confusing. The last time I programmed was with BASIC in the ‘80s. Since then, I have used Lotus123, Quattro, and now Excel. I have absolutely no experience with visual basic or VBA. I am looking at buying the book “VBA for Dummies”, to give me a leg up into using VBA. Is there a better, or easier, book for a beginner? Alternatively, what is the best way to learn VBA?
Reply With Quote
  #2  
Old 12-06-2019, 06:53 AM
jeffreybrown jeffreybrown is offline How to learn VBA? Windows 10 How to learn VBA? Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Honestly, a lot of time and effort and having a project to drive you. I've been poking around in Word VBA to help automate processes, but it's taking some time to learn and it's still confusing me at times. Word VBA seems to be quite different than say Excel VBA. This forum and many others are absolutely valuable tools to help in your growth in Word VBA, but don't just ask random questions. Have a plan and a goal and why you need the VBA. I've noticed there isn't one answer in VBA, so maybe find the method that works for you and stick with it. Thru time and effort you might be able to pick up different ways to do the same thing.

Finally, use the macro recorder to explore what is happening. It may code somewhat inefficiently;, but it works. Thru time you will begin to see how you can clean-up what the macro recorder spits out.

Below are a few resources that might help.

Microsoft Word VBA Macro Programming - Introduction | Udemy

https://www.amazon.com/exec/obidos/I...ncecheckbookA/

Microsoft Word MVP FAQ

Microsoft Word FAQ - Frequently Asked Questions - Help with Microsoft Word

Microsoft Word Help, Tips and Tutorials @ The Anchorage

Graham Mayor - Word Pages

Hopefully some of this helps.
Reply With Quote
  #3  
Old 12-06-2019, 09:38 AM
gmaxey gmaxey is offline How to learn VBA? Windows 10 How to learn VBA? Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,422
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

As for books, while it isn't dedicated to VBA, it has some good basic info and essential for customizing the ribbon. "RibbonX Customizing the Office 2007 Ribbon"
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Last edited by Charles Kenyon; 12-11-2019 at 01:34 PM.
Reply With Quote
  #4  
Old 12-09-2019, 02:23 AM
fransbosch fransbosch is offline How to learn VBA? Windows 10 How to learn VBA? Office 2013
Novice
How to learn VBA?
 
Join Date: Dec 2019
Location: Johannesburg, South Africa
Posts: 7
fransbosch is on a distinguished road
Default

Dear Jeffrey,

Re your comment, “This forum and many others are absolutely valuable tools to help in your growth in Word VBA, but don't just ask random questions. Have a plan and a goal and why you need the VBA.” I fully agree, and had already detailed my objective and asked for help in another thread. This thread was deliberately a bit of shotgun approach, and thank you for the valuable information.

Frans
Reply With Quote
  #5  
Old 12-09-2019, 02:24 AM
fransbosch fransbosch is offline How to learn VBA? Windows 10 How to learn VBA? Office 2013
Novice
How to learn VBA?
 
Join Date: Dec 2019
Location: Johannesburg, South Africa
Posts: 7
fransbosch is on a distinguished road
Default

Thank you, Greg
I will look at the links.
Frans
Reply With Quote
  #6  
Old 12-11-2019, 01:38 PM
Charles Kenyon Charles Kenyon is offline How to learn VBA? Windows 10 How to learn VBA? Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

A couple of more book recommendations:
Mastering VBA for Microsoft Office 365 by Richard Mansfield
Writing Word Macros: An Introduction to Programming Word using VBA: PhD Steven Roman


I thought the Udemy online course was worthwhile. Do not expect a lot of interaction with the instructor, though.
Reply With Quote
  #7  
Old 12-13-2019, 05:03 AM
fransbosch fransbosch is offline How to learn VBA? Windows 10 How to learn VBA? Office 2013
Novice
How to learn VBA?
 
Join Date: Dec 2019
Location: Johannesburg, South Africa
Posts: 7
fransbosch is on a distinguished road
Default

Dear Charles,

Thank you for the book recommendations. I think that I can see some book shopping in my future.

Thanks,
Frans
Reply With Quote
  #8  
Old 12-13-2019, 01:57 PM
Charles Kenyon Charles Kenyon is offline How to learn VBA? Windows 10 How to learn VBA? Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by fransbosch View Post
Dear Charles,

Thank you for the book recommendations. I think that I can see some book shopping in my future.

Thanks,
Frans

While I really like online resources, books have their place. I can find something in a book that it would take me forever to find among my web resources, and I have lots of resources! If nothing else, having the proper term or jargon can make an online search much more productive.
Reply With Quote
  #9  
Old 12-17-2019, 08:28 AM
fransbosch fransbosch is offline How to learn VBA? Windows 10 How to learn VBA? Office 2013
Novice
How to learn VBA?
 
Join Date: Dec 2019
Location: Johannesburg, South Africa
Posts: 7
fransbosch is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
While I really like online resources, books have their place. I can find something in a book that it would take me forever to find among my web resources, and I have lots of resources! If nothing else, having the proper term or jargon can make an online search much more productive.
I have to agree, as that's what I do within my fields of expertise. I have this habit of when I start on a new skill, my knee-jerk reaction is to look for the best book. I am a dinosaur from before the days of personal computers, let alone the internet and social media. Fortunately, there are people, such as you who then gently guide me back to reality. Thanks.

Btw, I do have an esoteric collection of books to fill the gaps. And for some subjects, paper can't be beat.
Reply With Quote
Reply

Tags
beginner, learn, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resources for beginners trying to learn VBA!! Charlesmartin Excel Programming 1 12-03-2019 08:04 AM
Need to learn how to change Degre decimals into DMS ferfer25 Excel 12 11-23-2013 11:11 PM
How to learn VBA? FREE resources to learn M$ products... zyzzyva57 Office 4 05-16-2009 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft