MicroStation VBA Fundamentals – $1,045

Session schedules subject to change.

Location Course Title Date Days
ONLINE MicroStation VBA Fundamentals – $1,045 Contact to schedule
MADISONMicroStation VBA Fundamentals – $1,04509/27/20162 days
MADISONMicroStation VBA Fundamentals – $1,04504/04/20172 days
MADISONMicroStation VBA Fundamentals – $1,04508/08/20172 days
Please enter number of students…
– Who need computer (Regular price) $1,045.00
– Who will bring own computer and software ($250 off) $795.00
By registering, you are agreeing to EnvisionCAD's Terms and Conditions.

 

Course Description

This 2-day course is for non-programmers to learn how to create their own MicroStation VBA macros to increase productivity for repetitive tasks and add their own commands to the MicroStation environment. The class will cover use of the VBA editor including designing VBA user forms, and modules.

Below is a chapter-by-chapter listing of the topics covered in the MicroStation VBA Fundamentals Class.

Topics Covered in This Session

1.VBA Basics
-Workspace Configuration Variables
-General Rules/Tips for MVBA
-VBA Project Manager Dialog
-Creating a New MVBA
-Record a MVBA
-Edit the MVBA
-Run a MVBA
-Autoload a MVBA
-Run a MVBA from a Key-in
-The VBA Editor
-VBA Project Explorer
-Properties Window
-Edit Toolbar
-Special Characters
-Using VBA Help
-Protecting VBA’s
-Message Boxes

2.Variables, Arrays and Collections
-Variables
-Declaration
-Variable Naming
-Common VBA Data Types
-Common MicroStation Data Types
-Constants
-Scope
-Enumerations
-Converting Between Data Types
-User-Defined Types
-Arrays
-Declaration
-Resizing
-Checking Array Boundaries
-Multi-Dimensional Arrays
-Collections
-Using the With Statement
-Declare all your variables

3.Procedures
-Subroutines
-Functions
-Optional Arguments
-By Reference or By Value
-Calling Subroutines and Functions

4.Decision Structures and Loops
-Conditional Expressions
-Arithmetic Operators
-Comparison Operators
-Logical Operators
-Decision Structures
-If Then Statements
-IIf Statement
-Select Case Statements
-Loops
-For…Next
-Do Loop

5.User Forms
-Creating UserForms
-Form Properties
-UserForm Toolbox
-Select Objects
-Label
-TextBox
-ComboBox
-ListBox
-CheckBox
-OptionButton
-Frame
-CommandButton
-Programming Control Events
-Click Event
-Other Control Events
-Verifying UserForm Text Inputs
-Interface Related Code Only
-UserForm Management
-Show
-Hide
-Unload
-UserForms Collection
-Modal vs. NonModal
-More on Message Boxes
-InputBox

6.String Manipulations
-String Comparisons
-Len
-StrComp
-Conversions
-LCase$
-UCase$
-StrConv
-StrReverse
-Search and Replace
-InStr
-InStrRev
-Replace
-Split and Join
-Split
-Join
-&
-Trimming
-Trim$
-LTrim$
-RTrim$
-Extracting Parts of a String
-Left$
-Right$
-Mid$
-Formatting
-Format$

7.Interacting With MicroStation
-CadInputQueue
-GetInput
-SendCommand
-SendDataPoint
-SendKeyin
-SendLastInput
-SendReset
-SendTentativePoint
-CommandState
-LastDataPoint
-LastView
-StartDefaultCommand
-Messages
-ShowCommand
-ShowError
-ShowPrompt
-ShowStatus
-ShowMessage
-Tool Settings Keyins
-Passing Arguments to a Macro

8.MicroStation Properties
-DesignFile
-ActiveDesignFile
-ModelReference
-ActiveModelReference
-Graphics Settings
-ActiveSettings
-Workspace
-ActiveWorkspace
-Windows Settings

9.Element Processing
-Element Enumerator
-Build From Element Scan Criteria
-Build From Selection Set
-Build From Fence
-Build From Complex Element
-Process Element Enumerator
-Recursion
-General Element Properties and Methods
-IsGraphical
-Type
-Level
-Color
-Line Style
-Line Weight
-DisplayPriority
-Transparency
-GraphicGroup
-Range
-ConstructVertexList
-Mirror
-Mirror3D
-Move
-Rotate
-RotateAboutZ
-ScaleAll
-ScaleUniform
-Rewrite
-Redraw

10.Creating New Elements
-Line Elements
-Arc Elements
-Ellipse Elements
-Shape Elements
-Text Elements
-TextNode Elements
-Cell Elements
-ComplexString Elements
-ComplexShape Elements

11.Autorun a VBA
-Module Containing OnProjectLoad
-Class Module Containing Event Handler

12.Error Handling and Debugging
-Error Handling
-The Error Object
-Basic Error Handling
-Advanced Error Handling
-Other uses for On Error GoTo
-Debugging
-Debug Toolbar
-Debug Function

Privacy Policy