?
Solved

Excel Macro VB Code

Posted on 2013-11-27
4
Medium Priority
?
283 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 2000 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 49

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 49

Expert Comment

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

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

762 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