Excel VBA Programming Basics Tutorial # 1 | Introduction to VBA | Writing Our First Macro

http://LLTtutorials.com In this Excel VBA Programming Basics Tutorial # 1 , we’re going to be writing our first macro and also getting to know vba.

Excel vba
Excel vba tutorial
excel vba programming
excel vba tutorial for beginners
excel vba introduction part 1
advanced excel vba programming
vba excel programming tutorialvba excel programming tutorial
vba excel programming tutorial 2013
writing our first macro

Intermediate or Advanced Office users may well be asking themselves “what next?” after they’ve mastered many of the more complex tools in most applications. Visual Basic is something that many people have heard of, but aren’t sure exactly what it is, or if it’s relevant to them. VBA is a programming language, so if you’re merely looking to gain further knowledge of Office without tweaking it directly with your own macros or additions to applications, it might not be for you.

VBA is, understandably, a derivative of Visual Basic, which you can code on a standalone basis, whereas VBA can be used within a “host” application (i.e. most MS Office packages, especially Word and Excel). More advanced users will recognise the use of VBA in existing applications such as Microsoft Visio, and Visual Basic is used in some non-Microsoft products such as AutoCAD and WordPerfect. Some Office applications have their own simple programming languages, for example, WordBasic for MS Word. However, you can do a lot more with VBA: it works very well within the standard Office applications.

Think of each Office application as a template you can alter, and you can start to understand how to use VBA. Applications are broken down into objects – for example, the menu bar in Excel is an object, as is the header and footer feature in Word. Each object has properties that you can alter, from a small level (making a sentence italicised), to a large level: editing the menu bar selections to suit yourself. All VBA does, in essence, is allow you to change the properties of such objects, perhaps where the existing functions don’t shortcut in the way you need. For example, if you frequently use the Verdana font in 36 point bold text, because it’s the corporate “look” you use in your stationary, you can program a hotkey to immediately give the object (the text) the properties (bold, size, etc) that you want – without having to go through the different menu items individually.

Here’s another example on how you can use VBA. Excel has a “weekday” function that will return each day of the week as a number (1 for Sunday, or Monday if you prefer, 2 for Tuesday and so on). However it might be more useful (especially when sharing your workbook) to have the names of the days shown, in case others don’t understand the numbers referring to days. There isn’t a function to do this, so you need a User-defined one, or UDF, that you can program yourself in VBA. It isn’t immediately obvious how you would use VBA, but actually, all Office programs have a VBA editor already built in.

If you’d think that someone, somewhere, would have already thought up an answer to the VBA problem you have (and need some code for) – you’d be right! There are literally thousands of sites with pieces of code, user-defined functions, macros and other helpful bits and pieces to get you going with VBA. If you get more experience, you could think about adding some yourself, if you think you’ve found the ultimate tweak to office to make it work better. If it’s useful and effective, go ahead and share it!

Author is a freelance copywriter. For more information on vba excel 2007 course, please visit http://www.microsofttraining.net

Article Source: http://EzineArticles.com/?expert=Rich_Talbot

Article Source: http://EzineArticles.com/4200008


Kapil Gaur says:


j aquesaulait says:

You have put a lot of videos up, kudos to you, and there’s a lot of good information, but you often labour explanations and use incorrect or ambiguous terminology, e.g. “put” instead of assign, “Over” instead of order.
Your videos could be more succinct if you prepared a script.  Well done for all the effort, though.

RK Palma says:

Cool! Thanks

Larry Yocum says:

Thanks! I am an experienced VB/VBA developer from say 1998 but I have not touched VB much since then. I needed this to show my son how to record/write/modify VBA macros for his first IT job. I will have him watch your series. And don’t worry, your English is fine.

Tanay Moore says:

You’re awesome ! Thanks !!

Saram Anil says:

your teaching way awesome man,keep it up like this.
We expect.. more videos from you, thanks….

JRD DoubleU says:


Cataleya La Fleur says:

Hi, thank you very much for the video. Could you please create a video to include codes for how to update options? Right now my options are working perfectly and I included an update/edit command button on my form. I have the codes for updating textboxes, but I don’t have the codes to update options. Thank you.

David Shamiri says:

Good work, funny and natural .. its okay if its not perfect

Narendra Singh says:

Awesome………….I am newbie and it’s very good for anyone who is new to vba he/she can learn easly with help of your videos..

 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!