Need help with Excel VBA learning. Any help will be apreciated.

[pedie]

Hi Dan, Vog, Brian, Norie, Lenze, AlphaFrog....Hi Everyone!!!

It been a while here in his forum and i have learn a lot...
Thanks to Bill and all the members esp the Moderators...!


Just wanted to ask if anyone can help me with excel VBA 2007, demo learning or some Video download etc...that i can download it and even if there is no netword i can practice office....Like Excel VBA learning DEMO book or staff like that which is not so taff to understand...
If you guys can advice me a link or Prvate msg me the download...may be in Utorrent or other file hosting....

Or you guys has a free copy please share...I found few of them but it is not procedural...it is mixed...and i have to find connection myself..


Thanks alot everyone!
Pedie

P.S: I usually check mrexcel in utube videos...bout those tricks....
And I have several videos download from his BLOG!!! If anyone is interested...pls check out MREXCEL.com in facebook. Very Cool tricks!

 

[Michael M]

Hi Pedie
Hiker95 compiled this list of everything Excel in the way of training and stuff

Training / Books / Sites:

How to Learn to Write Macros 
http://articles.excelyogi.com/playin...ba/2008/10/27/

How to use the macro recorder 
http://articles.excelyogi.com/

Click here and scroll down to Getting Started with VBA. 
http://www.datapigtechnologies.com/ExcelMain.htm

If you are serious about learning VBA try 
http://www.add-ins.com/vbhelp.htm

Excel Tutorials and Tips - VBA - macros - training 
http://www.mrexcel.com/articles.shtml

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

Creating custom functions
http://office.microsoft.com/en-us/ex...117011033.aspx

Writing Your First VBA Function in Excel
http://www.exceltip.com/st/Writing_Y...Excel/631.html

http://www.excel-vba.com/
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.exceltip.com/excel_links.html

(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0
http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

http://www.xl-central.com/index.html

http://www.datapigtechnologies.com/ExcelMain.htm

Dependent validation lists. Debra has a neat little tutorial here.
http://www.contextures.com/xlDataVal02.html 

Cascading queries
http://www.tushar-mehta.com/excel/ne...ing_dropdowns/

http://www.contextures.com/xlDataVal05.html 


Excel Data Validation - Add New Items
http://www.contextures.com/excel-dat...ation-add.html

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx

Locating files containing VBA
Searching Files in Subfolders for VBA code string:
http://www.dailydoseofexcel.com/arch...a-code-string/

http://www.pcreview.co.uk/forums/thread-978054.php

Excel 2003 Power Programming with VBA, by John Walkenbach

VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…
http://www.mrexcel.com/learnexcel2.shtml 

DonkeyOte: My Recommended Reading:

Volatility
http://www.decisionmodels.com/calcsecretsi.htm

Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Arrays
http://www.xtremevbtalk.com/showthread.php?t=296012

Pivot Intro
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Email from XL - VBA
http://www.rondebruin.nl/sendmail.htm

Outlook VBA
http://www.outlookcode.com/article.aspx?ID=40

Function Dictionary
http://www.xlfdic.com/

Function Translations
http://www.piuha.fi/excel-function-name-translation/

Dynamic Named Ranges
http://www.contextures.com/xlNames01.html

And, as your skills increase, try answering posts on sites like:
http://www.mrexcel.com/
http://www.excelforum.com/
http://www.ozgrid.com/
http://www.vbaexpress.com/portal.php
http://p2p.wrox.com/excel-vba-79/


Where to paste code in VBE VBA
Introducing the Excel VBA Editor
http://www.ask.com/web?qsrc=2417&o=1...cel+VBA+Editor

VBA for Excel (Macros)
http://www.excel-vba.com/excel-vba-contents.htm

VBA Lesson 11: VBA Code General Tips and General Vocabulary
http://www.excel-vba.com/vba-code-2-1-tips.htm

Excel VBA -- Adding Code to a Workbook
http://www.contextures.com/xlvba01.html 

Explanation and Examples of VBA
http://www.beyondtechnology.com/vba.shtml

Training for Excel, Access, VBA, with free downloads and course notes
http://www.fontstuff.com/excel/index.htm

VBA samples for Excel and outlook, couple of video tutorials

http://www.codeforexcelandoutlook.com

More VBA samples
http://msmvps.com/blogs/nateoliver

Simple short VBA for beginners with explanations
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm#J

 

[pedie]

Hi Michael, that was lots of infomation....I will have to go through each link one after another when I have time....

It must be very helpfull no doubt.

Is this how you learn to write VBA?
Or did you underwent some sort of trainings with VBA thing???

Just curious...!
Thanks again Michael!

Regards
Pedie

 

[Michael M]

Nope just keep doing it, looking stuff up, and learning from the people here that lend their expertise and time to each other.

 

[pedie]

Okay thank you mike.
I'm going to do the same thing...

Bye!

 

[Smitty]

The best way to learn VBA as a newbie is to play with the Macro Recorder. If you're technically oriented you can check out the VBA Programmer's Reference at www.msdn.com, but note that it is very technical.

There are also some good tutorials at Martin Green's www.fontstuff.com.

HTH,

 

[pedie]

Hi Smitty, thank you so much for inputting..I am checking it right away..I was watching videos from prev link and it was cool...!!!!

Thanks again

 

[Smitty]

I see your location is now New Zealand. Check out Ivan Moala's http://www.xcelfiles.com/.

He's a local.

 

[pedie]

Sure...Smitty!

I think your real name is Chris right???

Thats ok, i go with MrExcel username...