Further Details
MACROS
Running Macros
Where macros are stored
Assigning macros to buttons or a custom toolbar
Recording Macros
Entering a list of people's names
Formatting a cell
Adding a Header and Footer
Naming the three sheets
Inserting three more sheets and naming them
Running an Advanced Filter
Inserting a Logo
Exporting a Sheet to text
Create a Pivot Table
Protect a sheet with a password
Copy a range and paste the values into a new workbook
Open, Close, Save a workboko
THE VBA ENVIRONMENT
The Screen Components
Project Explorer
Project Properties
The Code Window
The Immediate Window
Finding
THE VBA ENVIRONMENT
The Screen Components
Project Explorer
Project Properties
The Code Window
The Immediate Window
Finding Macros
Export and Import VBA Modules
Add and Remove a module
ANALYSING VBA
Understanding the macro results
Understanding Code Formatting (Indents, etc)
Reading from and writing to a cell
Absolute vs Relative Referencing
Playing back VBA
Stepping through code
Stopping Code
Excel Objects and their hierarchy
Workbook
Range
Cell
Worksheet
Columns
Rows
Using the Offset property
Using the object browser
WRITING CODE
What is a sub procedure
What is a function
Formatting Objects
Cut / Copy / Paste
Deleting rows / columns / ranges / cells
Using Msgbox
Using Variables
Variable Types
Understanding Variable Scope
If
elseif
end if
Using With
Using Do
Loop
Creating a simple function
Understanding VBAs Operators (*, /, + etc)
Guide price
£150 |
