
In this Introductory course I'll be Introducing myself and the course to you. Its basically just a getting to know video
In this Excel VBA tutorial, we're going to start our lesson with some introduction then we're going to code our first Hello World Program.
In this excel vba tutorial, we're going to learn about Macro Recorder and learn advantages of using it.
In this excel VBA tutorial, we're going to get better understanding you VBA environment and look around it.
In this Excel VBA coding tutorial, we're going to learn about variables, why we use them, and how can we declare them.
In this Excel VBA coding tutorial, we're going to learn about some important statements in VBA such as Range,Cells,active cell etc.
In this excel VBA coding tutorial, we're going to learn how to control our workbooks and worksheets with VBA.
In this tutorial we're going to be learning about Functions
In this excel VBA conditional statements tutorial, we're going to learn about if then Else statement with many examples.
In this excel VBA conditional statements tutorial, we're going to learn about various ways of using Case statement with many examples.
In this Excel VBA loops tutorial, we're going to learn the Do while and Do until loop statement with examples.
In this Excel VBA loops tutorial, we're going to learn For loop statement with examples.
In this Excel VBA coding tutorial, we're going to get a deeper look at the MsgBox.
In this Excel VBA coding tutorial, we're going to get a deeper look at the inputbox.
In this first Excel VBA Forms tutorial, we're going to design and format our form.
In this Excel VBA tutorial, we're going to first code our close command Button, then we're gonna add labels and Text boxes.
In this Excel VBA coding tutorial,we're going to learn how we can access last non-populated row on our sheet with VBA.
In this excel VBA Forms tutorial, we're going to add new fields named Nationalities and Date of Birth.
In this excel VBA Forms tutorial, we're going to be replacing our Nationalities textbox with Combo Box.
In this excel VBA Forms tutorial, we're going to be adding extra two fields named Gender and Contact Number.
In this excel VBA Forms tutorial, we're going to be creating the same project above created using forms.
In this tutorial we're gonna learn how to trigger VBA code when opening excel Book.
In this tutorial I'll be showing you how to make an object variable and also show you how to use with Statement. With these two tips you can reduce the code amount by not repeating same code.
In this video I'm going to be showing you how to open notepad, notepad files, and Calculator using VBA as well as
In this video I'll make Excel VBA speak for us
In this lecture we're going to learn to create a simple program which is going to check duplicates for us
Last Update: 2-July-2017 : Make VBA Speak for us
Last Update: 22-June-2017 : Opening Notepad with VBA
Last Update: 17-March-2016 : Creating Duplicates exists program
Last Update: 6-Feb-2016 : How to paste data to new workbook and save it
Did you know that repetition is a curse, if you don't stop then you'll be wasting thousands of hours of your life. As an Excel user, you know that many times you create same sheet, with same formatting and same formulas, again and again. So, you're wasting thousands of hours, which you can spend with your family, or doing other important stuff.
Luckily, there is a tool or a language using which you can save those thousand hours of your life by creating a simple program which does the work for you. The program will create the sheet for you, it'll format it for you and it'll insert the formulas you. Not just that It'll protect your data in different ways.
Excel VBA, the programming language we're going to learn in this course which'll help you automate your daily tasks more smarter and more easier. You'll be able to tackle different and complicated situations easier.
So, don't waste anymore hour or second of your life and take this course immediately, uncover the tools which'll make your life easier.
Note: This course is available for free if you can't afford to buy it, just message me and I'll send you the link