|
eBooks |
|
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.
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
|
|
