Solved

Excel Macro VB Code

Posted on 2013-11-27
4
257 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
  • 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 46

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 46

Expert Comment

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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

810 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