COURSE SEARCH
 
   HOME > COURSES > LOTUS 1-2-3 R5.0 MACROS MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Lotus 1-2-3 R5.0 Macros




Course Aims
This course has been specially designed for users who want to make use of the more powerful facilities of Lotus for Windows, made available by the use of the MACRO programming language. Readers will be encouraged to approach the writing of macros using a structured modular technique. This method ensures that macros can be edited, amended and updated with the minimum of effort.
Assumed Knowledge
Lotus users who are confident in their use of the commands and functions available within the software gained by prior attendance on a "Lotus for Windows Advanced" course or via user experience. The course assumes that users do not have programming experience.
Course Audience
Existing Lotus for Windows users who wish to exploit the MACROS facility within the package to develop more sophisticated applications.

This course can be found in the following categories:
Courses > Lotus > Lotus 1-2-3

Table of Contents
Review of Functions
  		• Role of Functions
  		• Using Functions
  		• String Manipulation with Text Functions
  		• Logical Functions
  		• Logical Operators
  		• Lookup Functions
  		• Information Functions
     
    An Introduction to Macros
  		• What is a Macro?
  		• Why Use a Macro?
  		• Creating a Macro
  		• Recording Macro Commands
  		• Writing Macro Commands
  		• Naming a Macro
  		• 1-2-3 Keyboard Shortcuts
  		• Documenting a Macro
  		• Running a Macro
  		• Assigning a Macro to a SmartIcon
  		• Creating a Custom SmartIcon Palette
  		• Assigning a Macro to a Macro Button
  		• Debugging a Macro
  		• Macro Design and Layout
  		• Macro Libraries
  		• Print Settings in Macros
     
    Info Components
  		• What are Info Components?
  		• How to use Info Components
     
    Macro Commands
  		• Command Menu Equivalents
  		• Keyboard Equivalents
  		• Other Macro Commands
     
    Selecting
  		• Selecting Cells and Ranges
  		• Relative and Absolute Macro Recording
     
    User Input
  		• Labels and Numbers
  		• Arguments
  		• Choices
  		• Arguments
    Flow-of-Control Macro Commands
  		• Subroutine
  		• Branch
  		• Subroutine Versus Branch
  		• For Loop
  		• Conditional IF
  		• Return
  		• Quit
     
    Data-Manipulation Macro Commands
  		• Data-Manipulation Macro Commands
     
    Dialogue Boxes
  		• Creating a Dialogue Box
  		• Adding a Dialogue Box to a Worksheet
  		• The Dialogue-Description Table
  		• Copying a Dialogue Box Back to the Dialog Editor
  		• Displaying a Dialogue Box
  		• Types of Controls
  		• Push Buttons and Default Push Buttons
  		• Radio Buttons
  		• Check Boxes
  		• Edit Boxes
  		• List Boxes
  		• Static Text
  		• Combo Boxes
  		• Group Boxes
     
    User Defined Menus
  		• Adding and Removing Commands
  		• Disabling and Enabling Commands
  		• Creating and Inserting Menus
  		• Resetting Menus
  		• Examples
     
    Window and Screen Display
  		• Messages
  		• Panel Display
  		• Frame Display
  		• Window Display
     
    Automating Lotus 1-2-3
  		• Autoexecute Macro
  		• Auto123 File
     
    Appendix A - Function Keys
  		• Appendix A - Function Keys
     
    Appendix B - Macro Keys
  		• Appendix B - Macro Keys
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Sunday 20th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft