Files for download

Fell free to download the files and have a play. I have tired to annotate them to some degree with information about how the functions work.
For the files that contain macros I have tried to comment the macro explaining what is happening within the code.
Any comment are very welcome.

To view the code open the Visual Basic editor by using ALT-F11, or Tools --> Macro --> Visual Basic Editor.

To view the code that runs when one of the buttons is pressed in the Visual Basic Editor open Modules and double click on the module listed.

To view the code on a form right click on the form background and choose View Code.

  1. Adding items to a combobox
    2. This goes through a number of ways of populating a combobox.
  2. After updating a combobox
    3. This shows you how to update something, in this case another combobox, after a combobox has been changed.
  3. Array functions basic
    4. This shows how to enter an array formula and gives a simple example.
  4. Basic EPOS 1
    5. This is a simple Electronic Point of Sale idea. Have a look here first and then see how the idea can be developed further with the other EPOS examples.
  5. Basic EPOS 2
    6. This is a development of the EPOS.
  6. Basic EPOS 2a
    7. This is a further development of the EPOS.
  7. Basic EPOS
    8. This is the final version that tries to automate everything.
  8. Conditional formatting
    9. This shows how to use conditional formatting to shade a number of cells using a condition and how to sahd a whole row.
  9. Custom msgbox
    10. This shows how to get a masgbox to include user defined text.
  10. Cycling through worksheets
    11. This shows how to get Excel to cycle through all the worksheets in a workbook, applying the same action to each sheet.
  11. Date differences
    12. This shows how to use the DATEDIF function to calculate the difference between 2 dates.
  12. Example of login script
    13. This shows how you can cretae a simple login script. Note this is not fully secure but gives you an idea as to what can be done with Visual Basic.
  13. Full epos
    14. This is currently not working as I can not remember the password and the code fails as Microsoft are not longer supporting the Office Assistants in Windows 7 for Office version earlier than 2003.
  14. Full epos original
    15. This is a full implementation of the EPOS, the username is and password is.
    Explore the various sheets and the Visual Basic code.
  15. Lookup
    16. This is a simple vlookup.
  16. Lookup2
    17. This is a development of the Lookup workbook.
  17. Open Word file
    18. This simply shows how to get Excel to open a specific Word file.
  18. Pausing a macro
    19. This shows how to pause the running of a macro for a certain time and also how to get a form to close automatically after a given time.
  19. Text manipulation
    20. This show some of the text manipulations that you can do with Excel. There are different examples on all 4 sheets.
  20. Using offset and index functions
    21. This workbook goes through using the Offset and Index functions.