VBA Programming Tutorial
These Excel ('97 and 2000) files and Word files were done for the UK MEI Mathematics conference, Summer 2000. As such they were done whilst my Excel and VBA knowledge was much more impoverished than it is at present - enough said!
However, the associated Word files are quite detailed and will hopefully give the interested user a useful start if they are unfamiliar with the work.
Notice that, in addition to the Word files, the associated, completed Excel files are also provided (Though I suggest if you are learning that you DON'T actually look at them but work through the Word file instructions first). I have also included some additional Excel files that take some of the other files that little bit further but unfortunately no documentation is given with them. However, the interested user will be able to look at the VBA code and this together with some occasional worksheet comment boxes should be sufficient for their understanding - provided the more basic files have been looked at first (If not then please email me! mark@mfdabbs.com)
These Programming Files DO use some information from the "Named Range" files, therefore the reader is advised to use them as prerequisites to this work.
My advice is for you to download the files directly to your hard drive by right-clicking on the link and then selecting "Save Target As..." - otherwise the Excel files may not work fully in your browser window!
|
Word Files
|
Excel Files
|
Description |
|
ReadMeFirst
(40KB)
|
A quick read regarding Worksheet Calculation Modes will avoid confusion!! | |
|
Prog1
(121KB) |
Prog1
(21KB) |
A continuation of User Defined Functions (UDF's), together with some associated problems and solutions. (Automatic Calculation Mode needed) |
|
Prog2
(125KB) |
Prog2
(44KB) |
An introduction to worksheet control buttons. How to alter and read the values of worksheet cells from within VBA programs. (Automatic Calculation Mode needed) |
|
Prog3
(125KB) |
Prog3
(40KB) |
Efficient use of the code made by Macro Recorder. Further work on Dynamic Named Ranges and automatic graph updating. (Automatic Calculation Mode needed) |
|
Prog4
(103KB) |
Prog4
(42KB) |
An introduction to User Forms (Dialogue Boxes) and how they can control events. A automated tangent file is used from the Named Range 3 Tutorial to show how to incorporate a User Form into a file. (Manual Calculation Mode needed) |
|
Prog5
(101KB) |
Prog5
(40KB) |
More work on worksheet control buttons, in particular Spin Buttons. These are used to interactively change the Max/Min values of the x and y-axes on a graph. (Sorry - A few problems with this at the moment!) |
Links