
<!-- 

function surfto(form) {
        var myindex=document.examples_form.selectedIndex
        window.open(document.examples_form.path.value,"content");
}


function GetSelectedIndex() {
    return document.examples_form.Files.selectedIndex
}


function ShowText() {
   var selected_file=GetSelectedIndex();
   document.examples_form.description.value = "";
   document.examples_form.description.value = v_desc[selected_file];
   document.examples_form.path.value = v_path[selected_file];
}


function MakeArray(n) {
    this.length = n;
    for (var k = 1;k <= n; k++)
        this[k] = null;
} 

  var v_desc = new MakeArray(50);
  var v_path = new MakeArray(50);

  v_path[0] = "vba.shtml";
  v_desc[0] = "\r\n";

  v_path[1] = "vba001.shtml";
  v_desc[1] = "A little background information about Visual Basic and VBA.\r\n";

  v_path[2] = "vba002.shtml";
  v_desc[2] = "Description of VBA procedures.\r\n";

  v_path[3] = "vba003.shtml";
  v_desc[3] = "Description of a VBA subroutine.\r\n";

  v_path[4] = "vba004.shtml";
  v_desc[4] = "Making your code go.\r\n";

  v_path[5] = "vba005.shtml";
  v_desc[5] = "Introduction to VBA code modules and the Visual Basic Editor (VBE).\r\n";

  v_path[6] = "vba006.shtml";
  v_desc[6] = "Writing your first VBA procedure.\r\n";

  v_path[7] = "vba007.shtml";
  v_desc[7] = "About the importance of using remarks to provide internal documentation about procedures that will ensure your code is understandable and maintainable.\r\n";

  v_path[8] = "vba008.shtml";
  v_desc[8] = "If you are new to VBA and trying to get a handle on programming, this is a MUST READ article for you!\r\n";

  v_path[9] = "vba009.shtml";
  v_desc[9] = "Find out about variables on steroids.\r\n";

  v_path[10] = "vba010.shtml";
  v_desc[10] = "Discover a special, more flexible variety of arrays.\r\n";

  v_path[11] = "vba017.shtml";
  v_desc[11] = "Decision Structure that conditionally executes the embedded code\r\n";

  v_path[12] = "vba018.shtml";
  v_desc[12] = "Decision Structure that conditionally executes the embedded code\r\n";

  v_path[13] = "vba019.shtml";
  v_desc[13] = "Block Loop Structure to repetitively execute the embedded code\r\n";

  v_path[14] = "vba020.shtml";
  v_desc[14] = "Block Loop Structure for conditionally executing VBA code while or until a condition is true.\r\n";

  v_path[15] = "vba011.shtml";
  v_desc[15] = "An overview of ActiveX and COM in plain English\r\n";

  v_path[16] = "vba012.shtml";
  v_desc[16] = "Basics of a SQL Selection Query\r\n";

  v_path[17] = "vba013.shtml";
  v_desc[17] = "Basics of Sorting Results and Predicates\r\n";

  v_path[18] = "vba014.shtml";
  v_desc[18] = "Grouping Results and Aggregate Functions\r\n";

  v_path[19] = "vba015.shtml";
  v_desc[19] = "Working with multiple tables - includes examples of JOINs in SQL statements\r\n";

  v_path[20] = "vba016.shtml";
  v_desc[20] = "Action Queries - includes examples of INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP in SQL statements.\r\n";

  v_path[21] = "vba053.shtml";
  v_desc[21] = "How to force a line break in a message box.\r\n";

  v_path[22] = "vba051.shtml";
  v_desc[22] = "How to create a simple Function procedure with VBA for use in your spreadsheets to make dates appear as quarters.\r\n";

  v_path[23] = "vba050.shtml";
  v_desc[23] = "Calculating the difference in quarters between two given dates.\r\n";

  v_path[24] = "vba052.shtml";
  v_desc[24] = "A simple VBA procedure for Excel 97/2000 to print the full path of a workbook in the header or footer of a sheet.\r\n";

  v_path[25] = "vba054.shtml";
  v_desc[25] = "Here is a great Function procedure for business analysis you can create easily with VBA.\r\n";

  v_path[26] = "vba058.shtml";
  v_desc[26] = "Here is a simple Function procedure you can create with VBA to annualize the return on an investment.\r\n";

  v_path[27] = "vba055.shtml";
  v_desc[27] = "Select any range and then create a tabular log of the formulas and their respective cell addresses.\r\n";

  v_path[28] = "vba056.shtml";
  v_desc[28] = "Capture simple information from a user on-the-fly using a standard InputBox dialog available with VBA.\r\n";

  v_path[29] = "vba057.shtml";
  v_desc[29] = "How to capture a user's entry with a simple InputBox and ensure that the input is a valid future date.\r\n";

  v_path[30] = "vba059.shtml";
  v_desc[30] = "A simple statement you can use to stop screen flashing and make your procedures run much faster.\r\n";

  v_path[31] = "vba060.shtml";
  v_desc[31] = "How to show the hourglass.\r\n";

  v_path[32] = "vba061.shtml";
  v_desc[32] = "Trapping the Workbook object's BeforePrint event.\r\n";

//-->