VBA for MS Excel (Two Days)
- Getting started with macros
- Record and run macro
- Use absolute and relative references
- Use the personal macro workbook
- Copy a macro module to another workbook
- Assign a macro to an object, graphic, or control
- Add macros to the Quick Acess Toolbar
- Macro security
- Getting started with procedures
- Begin with a code module
- Create a procedure
- Understanding Excel objects
- Object properties
- Object methods
- Use the object browser
- Controlling cells, worksheets, and workbooks
- Work with cell related objects
- Automate worksheet and workbook operation
- appy formatting
- Working with dialog box
- Create a custom message box
- Create a custom input box
- Using conditional statements to make decisons
- Use If Then statement
- Use Select Case statement
- Using loops to repeat code
- Use For Next statement
- Use For Each...Next statement
- Use Do...Loop statement
- Working with variables
- Data type for VBA variables
- Declare and name variables
- Debugging and error handling
- Use debug window
- Break mode
- Handle run time error
- Writing user-defined functions
- Customize a function procedure
- Sample function to calculate salary
- Creating custom form
- Add a new user form object
- Use the Toolbox toolbar
- Use command button to take action
- Use checkbox and toggle button to set defaults
- Do calculation analysis by form inputs
- Other commonly used controls