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
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
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:
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top