VBA Video Tips
|   Home    |    Excel    |    Access   |   Word   |   VBA   |   Downloads   |   Contact   |   Index   |
eBooks

eBooks by Martin Green

Do you want to learn more about Access, Excel and VBA? Are you a teacher looking for top quality courseware for your students? My eBooks are the ideal solution to your needs. They are packed with code snippets, illustrations and step-by-step exercises. Written in the same style as my popular on-line tutorials, my eBooks will help you develop your skills and build useful, professional looking applications. Find out more at my eBooks Page.

 

VBA Video Tips

Here you will find a wide range of video tips for Microsoft Excel. I plan to add videos suitable for range of skill levels from absolute beginner to advanced user so check back occasionally for updates. The videos were recorded using Excel 2007 or 2010. To save space I have kept the video frames you see on this page quite small but the videos were all recorded at 1024x768 resolution and are best viewed at 720p (HD) quality. You can also view the videos full-screen. See the screenshots below for how to do this.

All the videos are hosted on YouTube so you can view them there if you prefer. Just click the YouTube link on the video player or visit my YouTube Video Tips Channel at www.youtube.com/martingreenvba.

How to change the video settings

Currently Available Videos for VBA

  • Build a Pop-up Calendar for Excel - Part 1
    The first of three videos that accompany my popular tutorial A Pop-up Calendar for Excel and is an excellent introduction to working with UserForms in VBA. The entry of dates is always a headache for people who use spreadsheets or databases. How should the date be written and in what format and what was the date of the third Thursday in October last year anyway? The answer is my pop-up calendar. Use a keyboard shortcut or right-click on a cell to ask for the calendar and all you have to do is pick a date. This short introductory video shows you what the calendar will look like and what it can do. [03:36]
  • Build a Pop-up Calendar for Excel - Part 2
    In this second video I show you how to create a UserForm in Excel's Visual Basic Editor. I add a command button and the calendar itself and write the VBA code to make it work, as well as a macro to open the calendar in Excel. [26:55]
  • Build a Pop-up Calendar for Excel - Part 3
    In the final video I enhance the calendar by writing some code to have it synchronise with an existing date, then add code to the workbook that defines a keyboard shortcut and creates a new item on the cell's right-click menu. Finally I convert the project file into an Excel Add-In for safe and easy distribution. [30:40]
^ top