Adding a User Form into an Excel Spreadsheet can really start to transform how your spreadsheet works. It is not as difficult as it may first appear and this video will walk you through the process of adding a form, changing the properties of the form and the way it looks. It then goes on to add a text field and button to the form. Make sure you listen to the advice on naming buttons – this is a really good habit to get into. Finally this video adds VBA code to the button to populate the text box on [More]
This video is one of Clayton Lock’s original videos and you can download the file used in this video. This video covers vital learning for anyone who wants to get started with creating VBA functions in Excel.    It starts by showing you how to create a simply Excel VBA function to display “hello world” on the screen and then goes on to show you how to do something far more useful with a function and return values to the cell that had the equation. This is longer than most videos on the site but I recommend you watch it all [More]
This video is one of Clayton Lock’s original videos and you can download the file used in this video. This video covers vital learning for anyone who wants to get started with Excel VBA.  Mastering the techniques in this video will save you hours and hours The video covers how to use break points in the Visual Basic Editor in Excel to stop code as it is working through.   It then goes on to show you how to use the watch function to check the values of any variable at any time in the code. You will also learn [More]
This short video shows how to create a very simple Excel VBA form and open and close it using VBA routines. I like this video because it is only 3.5 minutes long and it shows you in that time how to do everything you need to start adding VBA User forms to your Spreadsheet. Just a quick note the short cut key talked about in this video is F8 to step through a routine – i.e. every time you press F8 it moves down one line of code. You will soon learn that this is the best way to debug [More]
In this video we look at creating a DO LOOP in Excel VBA.  The DO LOOP arrangement allows the section of code between the DO command and the LOOP command to be repeated until a specified condition is true.  As the majority of VBA code you write will repeat a process for several lines of data getting to grips with this command will help you write clearer code. The example in this video is easy to follow and easy to replicate for yourself – so once you have watched the video have a go at getting it to work for [More]
This video introduces you to how to write code to work with sheets in VBA and shows you a few tricks with renaming, selecting and hiding sheets. Make sure you stay on the video until about 3.30 mins in as the video introduces you to the veryhidden property of a sheet.  I use this property a lot as it stops people unhiding them in the Excel interface. The video finishes by showing you how to select sheets with VBA. I hope you enjoy this video on Working with sheets in VBA – if you have found it useful or have any questions [More]
This is another great Excel VBA video that shows you how to add a formula to a single cell or a range of cells using VBA. The video is very clear and runs at a good pace (not too fast and not boringly as a result of being explained slowly). We also love the way that it shows you to add the formula in the cell first and then copy it into the VBA editor to make sure it is going to work – good tip guys! The video ends by showing you how you can enter the same formula [More]
This video shows quite an advanced method for finding the last cell with data in it either vertically or horizontally. We have never used this method in all the years we have been writing code but it is a pretty cool trick and well worth watching. It covers the .End(xlToLeft) function and the .End(xlUp) options for ranges. If you have learnt something new in this video (which we hope you have) please like or share it using the button above or leave us a comment below.
This video looks at how you can add values from your spreadsheet into drop down lists in a user form and VBA within your application. We like this video as it is clear and easy to understand and shows a really useful way to ensure that dropdown lists in a form are easily updated by a user without having any VBA experience or access to your code. Finally we really like the way the video shows you how to add a simple dropdown list and a more complicated multi column dropdown by using the .list method to add items to [More]
If you have never written a macro in Excel before then this is great video to start with. It introduces you to the Visual Basic Editor interface and how to type in a complete routine (from start to finish) to display a message box within your application. This is the first thing that all developers should learn to do and is often referred to as the “Hello World” example from the days when the first thing developers learnt to do with code was write “Hello World” on the screen! The video takes its time to explain this simple idea and [More]
This video shows some techniques that are vital when you write VBA code. Firstly it shows you how to use the InputBox function to ask users questions as your code runs (like a message box with a text entry cell it the form). It then goes on to show you how to use the IF statement which is probably the function you will use the most within your routine. However there are some times when there are too many options to write everything in IF statements and this is when you will need to use a SELECT CASE statement. The [More]
This video shows the different ways that you can reference cells within your VBA code. This is a fundamental skill you will need when writing VBA routines as it enables you to read and write values from the cells in the spreadsheet. We have listed the items covered and where they are covered in this video below to help you make the most of this video in the least amount time:- Adding data to cells (1.00) Selecting a different cell using the offset function (2.45) Adding data to cells using the offset function (5.00) Reading data from a cell using [More]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.