Visual Basic Code

VBA has a wide range of commands, functions and methods that can be used to create custom applications, and this tends to make VBA confusing for the beginner (or even the non-beginner). This chapter covers the basics that you will need to get started. 

---

Figure 4.7 Visual Basic code for another terminal velocity method.

Note that Visual Basic code activated by the command buttons SETUP , SOLVE and CHOOSE POLYNOMIALS provide for concerted calculations from the final worksheet. The code controlling these actions can be viewed using the command sequence ALT/Ell which renders the Visual Basic window visible. 

To examine the macro code that you have just recorded, choose Macro from the Tools menu and Visual Basic Editor from the submenu. Click on the node for the module in the active workbook. This will display the code module sheet containing the Visual Basic code. The macro should look like the example shown in Figure 13-7. 

This macro consists of a single line of code. You ll learn about Visual Basic code in the chapters that follow. 

Monte Carlo Simulation code (written in Visual Basic)... 

Fortran, C/C++, Visual Basic, or Delphi. The user provides the model coded as a corresponding subroutine or function. 

On the CD supplied with this book you will find Visual Basic software for the program RefFlsh. PPK equilibrium K values are calculated for each component in the program RefFlsh. Reference is made in the text to key code lines of this program. 

Gas bubble in oil-phase separation. The following Visual Basic line code is copied from the program Vessize. 

The same principal equations may be used for vertical three-phase separators. Simply, the Stokes law Eq. (4.3) is used for water drop separation from the oil phase. For liquid separation in the gas phase and for gas bubble separation in the oil phase, Eqs. (4.5), (4.6), and (4.7) are applied. These are the key equations in the VessizeV program Visual Basic line code. 

In Visual Basic (VB) program code line form, this equation would be written as shown in Eq. (5.2a). In this book both are considered interchangeable and may be used indiscriminately. 

The AirClr8 computer program s Basic language code listing is given in Fig. 5.13. This is a Quick Basic or common GW Basic code listing. With the exception of the input-output code, it is also applicable to Visual Basic. 

Now for the code under this Run Prog, command button. The copyrighted main body of code is not to be revealed and is of limited interest here. I therefore will list only the code specific to exhibiting the answers in their respective text boxes. After all, our objective is to reveal how to write inputs and outputs in Visual Basic rather than studying algorithms of a particular VB program. 

Visual Basic line code for driving a printer... 

BASIC, or Beginners Algebraic Symbolic Instruction Code, was developed by Kemeny63 as a "baby FORTRAN" for simple computers (e.g., minicomputers). BASIC does not wait for the whole user-written program to be finished, but compiled each typed line as soon as typed. It was ideally suited for a simple learning environment. Microsoft VISUAL BASIC is a GUI-interfaced version. Microsoft QUICK BASIC 4.5 is much better than FORTRAN embodiments in accessing instruments for real-time data acquisition and control. 

This IPC technology offers every IT department or automation manager the possibility to write and install in-house Visual Basic, C-h-, Delphi, or other coding language-based applications. 

The Group Theory Calculator [the GT Calculator] is the set of interactive EXCEL spreadsheet files, one for each of the main molecular point groups, on the CDROM supplied with this manual. The group theoretical calculations, which can be performed with the calculator, are rendered possible because of the enhancement of the basic spreadsheet operations and displays using Visual Basic for Applications code and the complex-arithmetic routines available in the Analysis Tool Pack EXCEL Add-ins . Since the Analysis Tool Pack is not one of the standard components loaded in a typical installation of the EXCEL software package, it is necessary, before attempting to use the GT Calculator, to ensure that your version of the EXCEL programme includes this extra component. With any spreadsheet open, check the Add-ins list in the TOOLS menu on the main EXCEL toolbar and, if necessary, install this component in the usual way. 

This book describes the approach to applied group theory that we have developed in the past twenty-five years and illustrates how this approach, known as the Spherical Shell method, can be applied to solve a variety of problems that benefit from a group theory analysis. To complement the theory, the book is supplied with a CDROM, on which interactive files, based on EXCEL spreadsheet technology controlled by Visual Basic for Applications [VBA] code, can be used to perform straightforwardly group-theory analyses for direct application to the simplification of physical problems in Chemistry, Physics and even Engineering Science. 

To access the Visual Basic Editor, choose Macro from the Tools menu and then Visual Basic Editor from the submenu. The Visual Basic Editor screen contains two important windows the Code window and the Project window. Procedures are viewed or typed in the Code window, which corresponds to a module sheet in Excel 95. Use the Project window to select a particular code module from all the available modules in open workbooks. These are displayed in the Project window, which is usually located on the left side of the screen. If the Project window is not visible, choose Project Explorer from the... 

To rename a Sub procedure, access the Visual Basic Editor and click on the module containing the macro. The name of the macro is in the first line of code, immediately following the Sub ke)rword. Simply edit the name. 

Activate the Visual Basic Editor. The VBA code module must be visible. 

The model was created using the proprietary spreadsheet package Microsoft Excel together with the programming code Microsoft Visual Basic. It runs on a standard personal computer (200 MHz, 64 MB RAM). Individual worksheets are allocated to each system component sub-model these are described in the following sub-sections. Non-capital cost items such as labour, maintenance and overheads are based on functions derived by Toft [2]. All capital costs are corrected where necessary to a total plant cost basis using methods defined in the same work. 

---