Chapter 2:
- Visual basic programming language: texted based languages (ex: python, C)
- VB vs VBA
- Subroutine, program & Sub
- Methods (set of arguments)
Chapter 3:
➔ firstName = InputBox(“Enter first name:”, “First Name”) -> Text in the dialog box
◆ First name is the title (Parentheses are required, no spaces)
➔ MsgBox”The product’s unit price is $2.4.”, vbInformation, “Selling price”
◆ No parentheses required, vblinfo → type of an icon
➔ There are 4 types of icons:
◆ VbInformation, vbQuestion, vbCritical, vbExclamation
➔ MsgBox InputBox(“Type your name.” “User’s name”), vbInformation, “User’s name”
◆ Must start with parentheses
➔ To write a statement that is more than one line → Use Space + underscore
➔ Functions of excel: we have to start with WorksheetFunction
◆ LN,SQRT,RAND → cannot be used
➔ String functions
➔ Specifying a property & Method
Week 6
Workbooks, charts and arrays
● Better messages format
○
● Saving workbooks
, ○
○
● Charts in VBA
○
● Chart properties
- Visual basic programming language: texted based languages (ex: python, C)
- VB vs VBA
- Subroutine, program & Sub
- Methods (set of arguments)
Chapter 3:
➔ firstName = InputBox(“Enter first name:”, “First Name”) -> Text in the dialog box
◆ First name is the title (Parentheses are required, no spaces)
➔ MsgBox”The product’s unit price is $2.4.”, vbInformation, “Selling price”
◆ No parentheses required, vblinfo → type of an icon
➔ There are 4 types of icons:
◆ VbInformation, vbQuestion, vbCritical, vbExclamation
➔ MsgBox InputBox(“Type your name.” “User’s name”), vbInformation, “User’s name”
◆ Must start with parentheses
➔ To write a statement that is more than one line → Use Space + underscore
➔ Functions of excel: we have to start with WorksheetFunction
◆ LN,SQRT,RAND → cannot be used
➔ String functions
➔ Specifying a property & Method
Week 6
Workbooks, charts and arrays
● Better messages format
○
● Saving workbooks
, ○
○
● Charts in VBA
○
● Chart properties
