×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Good Introduction to Visual Basic in Excel

Good Introduction to Visual Basic in Excel

Good Introduction to Visual Basic in Excel

(OP)
I've been an Excel user for the last 10 years or so and I am just getting into recording macros and now i want to begin to understand visual basic.  Just wondering what is considered the best introduction to visual basic.

RE: Good Introduction to Visual Basic in Excel

drt,

recommend starting in small steps and then progressing.  any literature by john walkenbach, steven bullen, or microsoft (although limited in information) is helpful.  john walkenbach and steven bullen have there own web pages with useful tips and vba code examples.  within google-groups, there is a wealth of posts regarding excel+vba by some "experts" or competent people.

the macro recorder is helpful is learning how code is created, but understand that once recorded, the exact steps will be repeated.  try recording a macro that simply copies and pastes data or formatting a cell (or range of cells).
creating custom functions that are globally available, hence simplify certain computations are useful!

be certain that the information you get pertains to the version of excel you have.

for me, i attended corporate sponsored week-long training seminar for vba in 1994 or so, which prompted me to pursue vba more at the time.  perhaps a seminar being held in your local area is available.
good luck!
-pmover

RE: Good Introduction to Visual Basic in Excel

drt,

In my case, I started out learning VB (just for my own interest) before I ever used VBA in excel.  For myself I found that just learning VB went a long way in using VBA because I didn't have to stuggle with the code writing in addition to how to work with Excels objects.  At any rate, the book that has served me well when I needed it is:

"Microsoft Excel VBA 2000 Programming" by Julitta Korol (Wordware Publishing Inc.)  ISBN 1-55622-703-5

RE: Good Introduction to Visual Basic in Excel

First, I'm not a programmer, but I have written a lot of VBA code to make my life simpler. I went with the trial and error method, using the online help (the paper clip) and the internet. I took one FORTRAN class in college so I was vaguely familiar with setting up code and declaring variables and some other basics--the only good thing to come out of that class. For the most part I still use the macro recorder and try to figure out what the code is doing. Just turn the recorder on and see what happens if you move the cursor one cell or select file>print or insert text, etc.

Other great places for help are the Microsoft newsgroups. Search for "excel [your problem]" on www.google.com under the groups section and you'll be flooded with information. Another site I like is http://www.mvps.org/dmcritchie/excel/excel.htm. And the Knowledge Base at http://support.microsoft.com. And hundreds more. That's probably enough to get you started and confuse you a bit. Then come back with more questions!

Patrick

RE: Good Introduction to Visual Basic in Excel

drt:

I started fooling around with VBA by using the macro recorder.  Sooner or later, however, you're going to figure out that it's only good for certain programs.  The most helpful guide I have is Microsoft Excel 2000 Power Programing with VBA by John Walkenbach.  The web is also a good source of information.

Good Luck!

jproj

RE: Good Introduction to Visual Basic in Excel

A good one is "Writing Excel Macros" by Steven Roman, published by O'Reilly. I purchased it specifically for information on how to work with ActiveX. The book is good and written, it seems, with engineers and scientists in mind.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close