Solved

Excel Macro VB Code

Posted on 2013-11-27
4
277 Views
Last Modified: 2014-06-15
Hello Experts Exchange
Is there a web page that can teach me how to understand simple VB code for Macros, I had a couple of questions on it in a interview test and would like to get a better handle on VB code for Excel.

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39680542
Try

http://www.dummies.com/how-to.html

But remember you must work on it to be able to learn it. Reading will not help. I recommend that you work on problems of your own and if you are stuck write to us here on EE. This, in my opinion, is the best way as you get the training with focus on "your needs" and not what some genius "thinks" you should need.
0
 
LVL 18

Accepted Solution

by:
Steven Harris earned 500 total points
ID: 39680887
Ran across this little site a while back...

HomeandLearn.org - Excel VBA Basics and Getting Started Guide

Another great way to learn the basics is to watch the Macro Recorder.  It does not create the most efficient code, but it will at least give you an idea of what what you are doing and how VBA can represent those changes/functions.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 39681213
Or you can Google vba tutorial and you'll find a lot of sites that will help.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 39688441
Did any of the above help you?
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question