Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Image from Google Jackets

Microsoft Excel VBA programming for the absolute beginner [electronic resource] / Duane Birnbaum.

By: Material type: TextTextSeries: For the absolute beginner (Series)Publication details: Indianapolis, IN : Premier Press, 2002.Description: 1 online resource (xii, 412 p.) : illISBN:
  • 0585439850 (electronic bk.)
  • 9780585439853 (electronic bk.)
Subject(s): Genre/Form: Additional physical formats: Print version:: Microsoft Excel VBA programming for the absolute beginner.DDC classification:
  • 005.133 21
LOC classification:
  • HF5548.4.M523 B572 2002eb
Online resources:
Contents:
Visual Basic for Applications with Excel -- Project: Colorful Stats -- Installing and Enabling VBA -- The VBA Integrated Development Environment (IDE) -- Getting to the IDE from Excel -- Components of the IDE -- Programming Components within Excel -- Macro Selection -- The Visual Basic Toolbar -- Getting Help with VBA -- VBA Help -- Constructing the Colorful Stats Program -- Requirements of the Colorful Stats Program -- Beginning Programs with VBA -- Project: Biorhythms and the Time of Your Life -- Variables, Data Types, and Constants -- Declaring Variables -- Data Types -- Constants -- Simple Input and Output with VBA -- Collecting User Input with InputBox() -- Output with MsgBox() -- Manipulating Strings with VBA Functions -- Fun with Strings -- Constructing the Biorhythms and the Time of Your Life Program -- Requirements for Biorhythms and the Time of Your Life -- Designing Biorhythms and the Time of Your Life -- Coding Biorhythms and the Time of Your Life -- Procedures and Conditions -- Project: Poker Dice -- VBA Procedures -- Event Procedures -- Private, Public, and Procedure Scope -- Sub Procedures -- Function Procedures -- Logical Operators with VBA -- Conditionals and Branching -- Constructing the Poker Dice Program -- Requirements for Poker Dice -- Designing Poker Dice -- Coding Poker Dice -- Loops and Arrays -- Project: Math Game -- Looping with VBA -- Do Loops -- For Loops -- Input Validation -- Validation with the InputBox() Function -- Validation with a Spreadsheet Cell -- Arrays -- One-Dimensional Arrays.
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

Includes index.

Visual Basic for Applications with Excel -- Project: Colorful Stats -- Installing and Enabling VBA -- The VBA Integrated Development Environment (IDE) -- Getting to the IDE from Excel -- Components of the IDE -- Programming Components within Excel -- Macro Selection -- The Visual Basic Toolbar -- Getting Help with VBA -- VBA Help -- Constructing the Colorful Stats Program -- Requirements of the Colorful Stats Program -- Beginning Programs with VBA -- Project: Biorhythms and the Time of Your Life -- Variables, Data Types, and Constants -- Declaring Variables -- Data Types -- Constants -- Simple Input and Output with VBA -- Collecting User Input with InputBox() -- Output with MsgBox() -- Manipulating Strings with VBA Functions -- Fun with Strings -- Constructing the Biorhythms and the Time of Your Life Program -- Requirements for Biorhythms and the Time of Your Life -- Designing Biorhythms and the Time of Your Life -- Coding Biorhythms and the Time of Your Life -- Procedures and Conditions -- Project: Poker Dice -- VBA Procedures -- Event Procedures -- Private, Public, and Procedure Scope -- Sub Procedures -- Function Procedures -- Logical Operators with VBA -- Conditionals and Branching -- Constructing the Poker Dice Program -- Requirements for Poker Dice -- Designing Poker Dice -- Coding Poker Dice -- Loops and Arrays -- Project: Math Game -- Looping with VBA -- Do Loops -- For Loops -- Input Validation -- Validation with the InputBox() Function -- Validation with a Spreadsheet Cell -- Arrays -- One-Dimensional Arrays.

Description based on print version record.

There are no comments on this title.

to post a comment.
Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in