This add-in turns a few letters into your choice of code, either a keyword, section of code or even a complete procedure or module.

To activate the add-in from the keyboard use 'Alt-A' then 'Alt-W'.

Setup

The add-in is supplied with eight entries created. To create a new entry click 'New' then enter the text you will type in the VB Code Window in the TextBox labelled 'Typed Text', say

sel

then enter the code the add-in will replace it with, say

select case <Cursor Position>

	case:

	case:

end select 

in this example the three letters 'sel' will be replaced by a shell Select Case structure.

Form_Resize Template

To save any changes click the 'Save' CommandButton. Clear any current code with the 'Clear' CommandButton. To delete an existing one select it in the grid and hit the 'Delete' key.

Just like Custom Error Handlers, 'Standard Elements' can be added to the code that the add-in will replace at runtime, the elements valid for Word Complete are listed below: -

• Project Name - The current project name
• ProcedureName - The current procedure name
• Module Name - The current module name, using the design described in Custom Error Handlers
• Current Control - The name of the current control - useful for coding event procedures
• Cursor Position - Specify the cursor position, especially useful for code that's still invalid as in the example above
• Username - The currently logged in user
• Date - The date, in the format 'dd mmm yyyy'
• Time - Current time in the format 'HH:MM'

Note: Only 10 entries can be stored in Word Complete in TurboVBLite