Solved

Excel Macro VB Code

Posted on 2013-11-27
4
264 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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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