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


Normal view MARC view ISBD view

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

By: Birnbaum, Duane.
Material type: TextTextSeries: For the absolute beginner (Series): Publisher: Indianapolis, IN : Premier Press, 2002Description: 1 online resource (xii, 412 p.) : ill.ISBN: 0585439850 (electronic bk.); 9780585439853 (electronic bk.).Subject(s): Microsoft Excel (Computer file) | Microsoft Visual Basic for Windows | Business -- Computer programs | Electronic spreadsheets | Microsoft Visual Basic for Applications | COMPUTERS -- Programming Languages -- C� | COMPUTERS -- Programming Languages -- Java | COMPUTERS -- Programming Languages -- PascalGenre/Form: Electronic books.Additional physical formats: Print version:: Microsoft Excel VBA programming for the absolute beginner.DDC classification: 005.133 Online resources: EBSCOhost
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 for this item.

Log in to your account 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


Visitor Counter