VBA tutorials - video

VBA tutorials - video

VBA concepts from Microsoft.com

1. Selection Object
2. Understanding Objects, Properties, and Methods
3. VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007
4. VB6 C# VB Code Converter
5. Excel Molar Mass Calculator - Molecular Weight
6. How to select cells/ranges by using Visual Basic procedures in Excel
7. Compile error when you edit a VBA macro in the 64-bit version of an Office 2010 program

VBA tutorial: create account here

8. VBA Code Examples

very good to use use Search the list below for free Excel VBA code examples complete with explanations.

Some include downloadable files as well. These Excel VBA Macros & Scripts are professionally developed and ready-to-use.

We hope you find this list useful!

9. Learn VBA Online Tutorial for Beginners

create an account to learn more tricks...

Interactive VBA Tutorial

Our interactive VBA tutorial is perfect for beginners or experienced users looking to brush up on their skills. Create a free account to save your progress and much more!

What is macro in VBA?

what are macros? Macros are what most people who write VBA code use. A macro (also can be referred to as a Procedure or Subroutine) is a grouping of code that performs a series of tasks or commands within a targeted computer program (aka Application).Jan 15, 2014

10. What is VBA used for in Excel?

on the left side panel, there are lot of good links to quick VBA practical start. need to take a look...

What is VBA used for in Excel?

VBA is used to write macros, which automate simple and complex tasks in Excel.

Users of Microsoft Excel will often find themselves repeating the same series of tasks over and over again. Sometimes these are minor tasks like copy-pasting subsets of data to different sheets, and sometimes the tasks are more complex like uploading data to a website. With VBA, macros can be programmed to automate tasks like these, turning a series of manual operations into a single button click.

Are VB and VBA the same?

The VBA language is identical to Visual Basic 6.0. If you have experience writing VB6 code, you can write VBA.

The VB Editor in Excel is a stripped-down version of the VB6 editor, with similar debugging capabilities and components like the ‘Project’ and ‘Properties’ windows. The Form editor is also very similar, although it has some limitations (like the inability to create control arrays).

Less similar to VBA is Visual Basic .NET. Although these languages share many of the same keywords and syntaxes, the code between these languages is less interoperable. You wouldn’t have to re-write much (if anything) to port a procedure from VB6 to VBA, but you couldn’t do the same from VB.NET.

What is the difference between a macro and VBA?

VBA is just the language that macros are written with. If your macro is a story, VBA is the grammar and dictionary it’s written with.

What is the difference between a macro and a script?

Scripts use a limited subset of the Visual Basic language and are used for different purposes.

Macros are stored inside Excel workbook files and can only be run from inside Excel. They’re typically used to automate various Excel functions and add extra functionality to workbooks.

Scripts are stored in text files using the .VBS extension and can be run from inside Windows or executed by other programs. Sysadmins will use scripts to automate certain administrative tasks on a computer or network.

11. VBA

300 good examples

12. Run a Macro from the VB Editor

Macros can also be run from the VB Editor. The VB Editor allows you to review a macro’s code and make any changes you want before running it.

Must-see Videos

13. Lesson 32.6 Spin Buttons in VBA
14. VBA Lesson 1 - Intro to VBA Macros - from ExcelVBASQL.com 38+ hours of Free training
15. Lesson 2.1 VBA Editor
16. Lesson 3.1 Project Explorer

it explains module well: 5 types. but generic module is important

17. Lesson 4.1 Properties Window
18. Lesson 5.1 Your First Macro

sub, function

19. Lesson 6.1 Variables
20. Lesson 7.1 Debug Toolbar
21. Lesson 8.1 Locals Window
22. Lesson 9.1 Watch Window
23. Lesson 10.1 Breakpoints
24. Lesson 11.1 Scope Of Variables
25. Lesson 12.1 Parameters In Sub Routines
26. Lesson 13.1 Functions
27. Lesson 14.1 Events
28. Lesson 15.1 Basketball Class
29. Lesson 16.1 References
30. Lesson 17.1 Object Broswer
31. Lesson 17. 2 Object Variables
32. Lesson 32.7 Toggle Button in VBA
33. Lesson 19.1 Relational Operators
34. Lesson 27.1 Arrays
35. Lesson 27.6 1D Dynamic Array
36. Lesson 27.5 Populate a 2D Array from Excel
37. Lesson 27.4 A real work example of Arrays in VBA
38. Lesson 27.2 Populate And Loop Over and Array
39. Lesson 27.3 Populate a 1D Array from a worksheet

videos from British guy

42. Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros
43. Excel Visual Basic (VBA) for Beginners - Part 2 of 4: Change Cell Values
44. Excel Visual Basic (VBA) for Beginners - Part 3 of 4: Positioning and Offset
45. Excel Visual Basic (VBA) for Beginners - Part 4 of 4: Loops
46. 17 Things Beginners Must Know About The Excel VBA Editor

it demos how to use debugger. very useful.

very good knowledge for common sense and basic stuff. we need them.

47. Excel VBA to Move Data Around A File - How I Actually Do It! P1
48. Excel VBA to Move Data Around A File - How I Actually Do It! P2
49. How to Use Excel VBA Code - Real Example P1

it has 13 posts

50. 7 Excel VBA Essential Beginner Techniques: Execution
51. 17 Things Beginners Must Know About The Excel VBA Editor

need to watch this first. basics and debug tricks

52. Excel VBA for Post-Beginners: (1/6) Series Introduction
53. How To Create A Custom Navigation System In Excel - Part 1/6
54. Before You Start Excel VBA, WATCH THIS!

VB script tricks

55. Compare Two Excel Files