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]
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]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.