Main reasons to use VBA -To automate commonly used tasks
-It is NOT easy to undo tasks run by VBA script by using the undo button. Once you run the code, there is no undo button.
-To create a user interface

-Know what Procedures, Macros, Modules, Commands, objects, property, methods (like delete, select, copy, Value, etc.) functions (like Excel’s Max, Min, Offset, etc,) range, variable are and be able to define and provide examples

Know the syntax to declare a variable and set its data type
-Dim VariableName as Variable type.
All variable declarations start with dim.
Examples of Variable type: string, double, integer
For example: Dim City as String. What does this line of code do? Our variable is named City. The type of variable is String. It declares the name and type of the variable.
Know all of the variable types and what kind of data they can store. Boolean (t/f), Double (real #s), Integer (whole numbers), String (text), Range, etc.

Go back and look at the homework, step through the code, take the topics and look at an example

Know the difference between writing to a spreadsheet and reading from the spreadsheet
Range(“A2”).value = “itemCost”
Value means we’re going to take cell A2 and make the value equal ItemCost. ItemCost is in quotation marks, so that means it is TEXT.

And reading from the spreadsheet-
ItemCost = Range(“A2”).Value
In one, we’re putting data in, and the other (reading,) we’re setting itemcost equal to whatever the value was of A2. In writing, ItemCost is text. In the case of reading, ItemCost would be variable.
Variables are used primarily to store data.

Know the general syntax for If/Elseif/Else/then statements
If condition 1 then
Action 1
ElseIf Condition 2 then
Action 2
Else
Action 3
End if

Where the Else represents the False statement

Know that Range Names and Variable names in VBA are case sensitive
But VBA commands and Properties are not case sensitive

Know what the Exit Sub procedure does.
-To stop running the current procedure code if some condition is met
If you fuck up it will give you an error and kill the code, so you can’t go any further. The condition can be something like “you have to spell your product correctly.”

Offset 1,0 means 1 row down, 1 column right (I think??)

Range variable types require the VBA programmer to use SET in addition to naming the ariable

Know the syntax for a Message box

____ “message to user”, vbButtonType, “title”

Common object types include: things that we can manipulate with our methods. Such as:
-an excel worksheet
-an excel workbook
-a command button
-an input box
They’re basically nouns

Know the syntax Application.WorksheetFunction is used to utilize excel functions to use in VBA coding
Know the syntax for the Offset function such as:
Range(“StartHere”),Offset(Rows,Columns),interior.color=vbBlue
See completed files of HW7, Sample HW7, Lecture 4.3, lecture 4.4

Know the syntax for selecting and naming a range such as:
The From Range
Range(Range(“StartHere”).Offset2,0)

After the comma is the To Range
Range(“CompStart”).End(x(Down).End(xToRight)

Name is the method
Name=”CompanyInfo”
See completed files of Hw7, Hw8, lecture 4.3, 4.4, cumulative VBA review notes on scholar

Value = Application.WorksheetFunction.VLookup(CompName,Range(“CompInfo”),4,False)
Know the syntax for sorting and that in order to sort on a field the Key must be spelled exactly like it is in the table you are sorting.

Difference and how to identify a static versus dynamic range

Know how to use and what the unverscore character does in a VBA procedure. – will wrap lines of VBA code.
Know the syntax for the With construct and that it is primarily used to simplify the coding for repeating object names

Know the difference and how to desire public versus private variable. Public, declare them once.
Lecture 4.3 and VBA notes

Know the difference and how to use data validation (define restrictions on what type or kind of data could be or should be entered into a cell)

Know the difference between stop, warning and information. 2 of those will allow user to override data validation rule; warning and information.