Macros in Excel
Upcoming dates for this workshop January 27
9:00 AM - 4:30 PM  Macros may be used to record and save a series of steps in order to recall and execute the steps whenever needed. Recorded macros can accept keystrokes, menu choices, text, formats, and formulas.
However, macros have the potential to do far more than simply record steps. By using Visual Basic for Applications (VBA), which is already built in to Excel, you will be able to greatly enhance macros. VBA allows you to create forms and other objects, modify their properties/methods, and create procedures that cannot be recorded, such as repetitive loops, selection structures, and user input devices.
Prerequisites:
Description coming soon.
Topics Include:
- Record complex macros including use of relative option
- Attach macros to icon, button, or keystroke
- Create User Defined functions that appear under Insert Function list
- Introduction to coding terminology and techniques
- Modify or create macros using Visual Basic (VBA) editor
- Use coding functions (Val, Format, IsNumeric, IsDate, InputBox, MsgBox, Ucase)
- Work with VBA Excel objects (cells, range, selection, ActiveCell) and related properties
- Create forms and add objects (listbox, button, label, textbox, option button, checkbox)
- Work with Methods (SetFocus, Hide, Show, OpenForm, Sort, PrintOut)
- Create Event procedures for Click, GotFocus, Open, Close, Load, Unload events
- Construct VBA statements
|