Microsoft Excel VBA programming for the absolute beginner

• 作者: Birnbaum, Duane.
• 出版: Boston, Mass. : Thomson Course Technology 2005.
• 版本: 2nd ed.
• 稽核項: 1 online resource (xii, 489 pages) :illustrations.
• 標題: Business , Programming LanguagesC♯ , Microsoft Excel (Computer file) , COMPUTERS , COMPUTERS Programming Languages -- C♯ , Computer programs. , COMPUTERS Programming Languages -- Java. , Business Computer programs. , Microsoft Visual Basic for applications. , COMPUTERS Programming Languages -- Pascal. , Electronic books. , Programming LanguagesPascal. , Programming LanguagesJava. , Electronic spreadsheets.
• ISBN: 1592007295 , 9781592007295
• ISBN: 1592007295
• 試查全文@TNUA:
  
• 附註: 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 -- Multi-Dimensional Arrays -- Dynamic Arrays -- Programming Formulas into Worksheet Cells -- A1 Style References -- R1C1-Style References -- Constructing the Math Game -- Requirements for the Math Game -- Designing the Math Game -- Coding the Math Game Program -- Basic Excel Objects -- Project: Battlecell -- VBA and Object-Oriented Programming -- Objects Defined -- VBA Collection Objects -- The Object Browser -- Top-Level Excel Objects -- The Appli
• 電子資源: https://dbs.tnua.edu.tw/login?url=https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=134926
• 系統號: 005318515
• 資料類型: 電子書
• 讀者標籤: 需登入
• 引用網址: 複製連結
• 目前引用數