Private Sub OK_Click( ) and
Dim ....
End Sub

Following the Private Sub .. statement, enter a Dim statement to define any variables used within the code executed by this command button. Values already defined when constructing Text boxes (the Name value) do not need to be defined.

The following sections contain pieces of Visual Basic code that perform specific functions.

• File operations

  .. Choose action ... Check that folder exists Check that file exists Copy/Move folder and sub-folders Create and Use a INI file Display File Structure to Select a File Insert Folder into Displayed Folder Structure List folders List files Locate files Read a Binary File Read a Sequential File Rename a File Select a Folder Test for a Folder

• Testing for conditions

  .. Choose action ... Check for non-numerics at a fixed location Check for numerics at a fixed location Error handling Fuzzy Testing of Strings Gathering Timer Value Get Logged on Windows Userid Strip arguments out of a string Testing for Radio Button Conditions Testing for Checkbox state

• Program flow

  .. Choose action ... Causing programs to wait (sleep) Calculate elapsed time Check Data Retrieved from Clipboard Forms as Subroutines Forms with Selected Values Gathere Process Information Read passed parameters Run browser wait for end Subroutines Terminate An Application Terminate A Program in the Task Manager List Use external program and wait

• Input/Output from/to screen

  .. Choose action ... Copy to from Clipboard Drop-down list Combobox Dynamically size a form Hide/Display a box Hide/Display Menu Bar Items Input box Menu bar Modify Menu Bar Items Programmaticaly Messages Multiple selection from list Multiple lines on screen Process multiple lines on screen Radio buttons

• Interface to Internet

  .. Choose action ... Setup WGET Interface Click Link using WebBrowser Display progress Download and convert PDF file to text FTP Upload Find location from ip address Interface to Google Persistent Internet Errors Post a form on a web page Read a web page Read a web page (binary) Read a web page allowing for SSL Save a Page using Mozilla Save a Page using WebBrowser Send email Setup Internet Interface Wait for command to complete

• Interface to Excel

  .. Choose action ... Setup Excel Interface Access Excel Spreadsheet Add a Graph to a Worksheet Add a formatted Graph to a Worksheet Add a Worksheet Count Worksheets Create a Workbook Check a Worksheet exists Clear Excel Worksheet Column Close Excel Interface Delete a Graph from Excel Determine Number of Lines in a Worksheet Disk Paths From Application Location Find worksheet in workbbok Format Data Format Cells Generate Random Number Normally Distributed Get URL from hyperlink cell Loop Reading Data Read and Save CSV data Rename worksheet Terminate Excel Interface Use Excel functions Write Hyperlinks to Excel

• Manipulating data

  .. Choose action ... Convert hex to decimal and ascii character Correlation Determine Intervals in Music Score Format dates Fuzzy string comparison Generate random number in range Generate random number from a normal distribution Matrix Multiplication Run Solver Sort data Strip string out of buffer Testing for Normal Data

• Audio Applications

  .. Choose action ... Basic MIDI setup Determine Intervals in Music Score Midi File Format Midi MThd Section (header) Midi MTrk Section (track) Midi Messages Note basics Open MIDI device Play Audio Programmatic Assembly/Dis-assembly MIDI file Skeleton Midi Files for Programmatic Assembly

• Evolutionary Algorithm

  .. Choose action ... Cross-Validation to Determine K in knn Machine Learnin Generate Initial Population Genetic Programming Generate Random Number Within a Range Probabbilities of crossover and mutation Roulette Wheel Selection Weightings for KNN Machine Learning

• Bayesian Network

  .. Choose action ... Access model nodes Determine and set states in a node Establish environment List nodes within a model Load a model Number of states in a node