Vba

Joesif

Board Regular
Joined
Feb 23, 2010
Messages
65
Hi

I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find works best for them. Are there any good guides knocking about to look at

Cheers
Joe
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
11,936
Office Version
2013
Platform
Windows
This is just one of many websites where you can get free tutorials on VBA.

http://www.excel-vba.com/excel-vba-solutions-beginners.htm

I am self taught and had to learn of necessity back in the twentieth century. My advice.
1. Think logically and digitally.
2. Get a personal project to build a code for.
3. Draw a diagram of the steps you want the project to accomplish.
4. Use the macro recorder to record the steps.
5. Tie the steps together at some point to make a program.
6. Learn how to troubleshoot the code by debugging your code and streamlining it to remove the select and activate methods that the recorder produces.
7. Don't be ashamed to ask for advice from co-workers. We all have to learn by trial and error, even if we have a professional tutor.
8. Don't be afraid to try code you write. The worst that can happen is making a perpetural loop or corrupting a file. Ctrl + Alt + Delete can cure most unexpected results, but it also eliminates and unsaved code.
9. When you think you have a good understanding of how VBA works, then you can use the forums help you develop specific code and solve problems.
10. Last but not least, learn to use the VBA help files that are accessed through the vb editor screen and if you can afford it, by a book on VBA programming.
 
Last edited:

Joesif

Board Regular
Joined
Feb 23, 2010
Messages
65
Thanks for the reply some great advice for me to start with
 

Watch MrExcel Video

Forum statistics

Threads
1,099,784
Messages
5,470,743
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top