MicroStation VBA Fundamentals
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.
16 hours of instruction, subject to change based on specific needs.
Topics Covered
Books
Online
- Workspace Configuration Variables
- General Rules/Tips for MVBA
- VBA Project Manager Dialog
- Creating, Editing, Recording, Running, and Autoloading a New MVBA
- Run a MVBA from a Key-in
- VBA Editor and Project Explorer
- Properties Window
- Edit Toolbar
- Special Characters
- Using VBA Help
- Protecting VBAs
- Message Boxes
- Variables
- Declaration
- Variable Naming
- Common VBA Data Types
- Common MicroStation Data Types
- Constants, Scope, and Enumerations
- Converting Between Data Types
- User-Defined Types
- Arrays
- Declaration
- Resizing
- Checking Array Boundaries
- Multi-Dimensional Arrays
- Collections
- Using the With Statement
- Declaring Variables
- Subroutines
- Functions
- Optional Arguments
- By Reference or By Value
- Calling Subroutines and Functions
- Conditional Expressions
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Decision Structures
- If Then, IIf, and Select Case Statements
- Loops, For…Next, and Do Loop
- Creating UserForms
- Form Properties
- UserForm Toolbox
- Select Objects
- Label
- TextBox, ComboBox, ListBox, and CheckBox
- OptionButton
- Frame
- CommandButton
- Programming Control Events
- Click Event
- Other Control Events
- Verifying UserForm Text Inputs
- Interface Related Code Only
- UserForm Management
- Show, Hide, and Unload
- UserForms Collection
- Modal vs. NonModal
- More on Message Boxes
- InputBox
- String Comparisons
- Len, StrComp, and Conversions
- LCase$, UCase$, StrConv, StrReverse, and Search and Replace
- InStr, InStrRev, Replace, Split and Join, Split, and Join
- &, Trimming, Trim$, LTrim$, and RTrim$
- Extracting Parts of a String, Left$, Right$, Mid$, Formatting, and Format$
- String Comparisons
- Len, StrComp, and Conversions
- LCase$, UCase$, StrConv, StrReverse, and Search and Replace
- InStr, InStrRev, Replace, Split and Join, Split, and Join
- &, Trimming, Trim$, LTrim$, and RTrim$
- Extracting Parts of a String, Left$, Right$, Mid$, Formatting, and Format$
- CadInputQueue, GetInput, SendCommand, SendDataPoint, SendKeyin, SendLastInput, SendReset, and SendTentativePoint
- CommandState, LastDataPoint, LastView, StartDefaultCommand, and Messages
- ShowCommand, ShowError, ShowPrompt, ShowStatus, and ShowMessage
- Tool Settings Key-ins
- Passing Arguments to a Macro
- DesignFile, ActiveDesignFile, ModelReference, and ActiveModelReference
- Graphics Settings, ActiveSettings, WorkSpace, ActiveWorkSpace, and Windows Settings
- Element Enumerator
- Build From Element Scan Criteria, Build From Selection Set, Build From Fence, and Build From Complex Element
- Process Element Enumerator, Recursion, General Element Properties and Methods
- IsGraphical, Type, Level, Color, Line Style, Line Weight, DisplayPriority, Transparency, GraphicGroup, and Range
- ConstructVertexList, Mirror, Mirror3D, Move, Rotate, RotateAboutZ, ScaleAll, ScaleUniform, Rewrite, and Redraw
- Line Elements, Arc Elements, Ellipse Elements, Shape Elements, and Text Elements
- TextNode Elements, Cell Elements, ComplexString Elements, and ComplexShape Elements
- Module Containing OnProjectLoad
- Class Module Containing Event Handler
- Error Handling, Error Object, Basic Error Handling, and Advanced Error Handling
- Other Uses for On Error GoTo, Debugging, Debug Toolbar, and Debug Function
13 chapters | 198 pages
$100
Contact to Purchase
Get the eBook and read it anywhere. Buy or rent our eBooks through VitalSource. They are 100% offline and include interactive study tools.
PURCHASE eBook
Stay put.
Instructor-led online training can be set up for you or your group. Submit the info below and we’ll be in touch.