VBA Enterpad for Excel & Word for Windows
- Product Overview
- System Requirements
- Layout of keys on the Enterpad vs macro names
- How do macros run?
- Internal operations of the Enterpad
- Technical Support
The VBA Enterpad saves precious time and prevents errors for those who need to run frequent VBA code (macro/sub). With native features that allow it to work seamlessly with Excel and Word for Windows, the VBA Enterpad offers a level of reliability not possible with other input devices.
Take your VBA knowledge to a new level and develop the ultimate time-saving solution for your (or your customer's) business. The Enterpad's overlay templates make the integration process easy and the results professional, while providing ease of use to users.
- Connects like a standard keyboard
- No special driver required
- Spill proof; easy to keep clean
- Protection against static electricity
- Trigger VBA macros without using keyboard shortcuts
- Can be used as a stand-alone unit or with a standard keyboard
- Membrane with 120 keys
- Up to 4 macros per key (can trigger 460 VBA macros)
- Buffer of 12 keys
- Adjustable level of audible beep (loud, medium, low and mute)
- Overlay templates available
- No external power supply required
- Overlay sheet cover included
- Enterpad dimensions: Width 19.8 cm (7.8"), height 25.3 cm (9.96"), depth 3 cm (1.25")
- Overlay sheet dimensions: Width 18.4 cm (7.25"), height 21.6 cm (8.5")
- Number of keys: 120, 10 X 12 matrix
- Membrane: Sealed with > 1 million contacts per key
- Membrane: Scratch-, dust- and spill-resistant
- Plug: USB
- Plug cable length: 1.8 m (6') shielded
- Approx. weight: 710 g (1 lb. 9 oz.)
- Approx. shipping weight: 910 g (2 lb.)
- Operating Temperature: 10 to 35 C (50 to 95 F)
- Storage Temperature: -5 to 50 C (23 to 122 F)
- Humidity: 5-95 % RH non-condensing
- Current consumption: Max. 17 mA = 1/10 watt
- CSA 108.8-M1983 / FCC class A (commercial)
- Casing available in Beige or Black
- One available USB port
- Windows XP or newer
- Microsoft Excel and/or Word with VBA & COM support
Connect the Enterpad to a free USB port on your computer. If you are using a USB hub, connect the Enterpad to that hub.
Allow the operating system to automatically detect the Enterpad (normally less than 15 seconds). Once detected, a confirmation bubble will appear in the taskbar near the clock. The Enterpad will then be ready to use.
Use the Enterpad with our VBA linker program to connect it to the VBA code of any active applications (Excel & Word). The linker is a portable application, meaning there's no installation process. You just download two (2) small and digitally signed files to be placed in the same folder:
Running (double clicking) the file 'EP2VBA.exe' will link the VBA Enterpad to any active Excel or Word application. If you want to automatically run 'EP2VBA.exe' when starting your computer, simply put a shortcut to it in the startup folder.
Layout of keys on the Enterpad vs macro names
Each key number on the Enterpad can trigger its equivalent macro name in the Excel/Word file. The first key (1) on the Enterpad will trigger the macro "EP_1", the second key (2) will trigger the macro "EP_2", and so on. An Excel/Word document must be active, the macro name must exists and the document must not be locked (when editing).
Key #1 is located at the top left corner and key #120 is at the bottom right corner. The "shift" key of the Enterpad adds 120 more to the key number. Key #1 then becomes key #121, and so on up to #230. This provides a way to trigger 110 additional VBA macros.
A macro can be triggered with the key #111 even though it is used as the "shift" key. Unlike the other keys, the macro will be triggered when it is released if, of course, another key has not been pressed before it was released.
How do macros run?
The way the macros of the VBA Enterpad are executed is designed to meet the needs of an average user. We offer custom development services for those who need a different way of execution.
The VBA Enterpad associates each of its keys with a macro name that includes its number. Thus, using the first (physical) key of the Enterpad attempts to execute the macro EP_1, and the last one, the macro EP_120.
To continue, it is necessary to consider that Excel and Word applications can open multiple documents at the same time. Only one document is active (usually the last used) per application. This means that two documents will be active at the same time if the Excel and Word applications are launched. Keep in mind that an active document remains active even if its window is not active (does not have focus).
Excel has priority over Word! The Enterpad is designed to run one (and only one) macro per use. It will first try with the active document Excel. If a macro is executable, it will be executed without more. Otherwise, it will try with Word. If a macro is executable, it will be executed. Otherwise, an information message will be displayed.
For various reasons, some users (they will recognize themselves) launch a new Excel / Word application for each document to be opened. In this case the Enterpad will try to communicate with the active document of the first application launched (Excel or Word).
And if it stops! The Enterpad always waits for a macro to finish before launching another one. If a macro fails (problem / bug), resetting the VBA editor will allow the Enterpad to continue running macros. In the meantime, the Enterpad will continue to receive (up to 12) requests for macro execution. A reset of the Enterpad will cancel all requests that follow the one in execution.
Internal operations of the Enterpad
By default, the 10 keys of the bottom row of the Enterpad are used like other keys. This chapter explains how (and why) they can be used to do double-duty.
The shift key on the Enterpad enables the user to trigger 110 more macros ("EP_121" to "EP_230"); Pressing (and holding) the shift key, then pressing the first key (top-left corner) of the Enterpad simultaneously, will trigger the macro "EP_121" (120+1), and so on up to the macro "EP_230".
The shift key is the Enterpad key #111. If you press it then release it before pressing another Enterpad key, it will trigger the macro "EP_111".
The shift key can also control 9 internal settings/commands of the VBA Enterpad. The following sections explain how.
Adjust audible beep
When used with the shift key, three keys can be used to choose the level of the audible beep.
The choices are 'HI' for loud, 'MED' for medium and 'LO' for low. The most recent choice will be held in memory until changed, even if the power is turned off.
Load confirmation required
This setting is not relevant for the VBA Enterpad operation.
Its default setting (OFF) means that no confirmation will be required if you would like to transform your VBA Enterpad to a standard Enterpad by way of the Enterpad's configuration software (EPConfig).
To set or unset this option, the keys "OFF" and "ON" in the shift mode must be used. The most recent setting will remain in memory until you change it, even when the power is turned off.
Load confirmation or Factory reset
The 'LOAD' key used with 'SHIFT' is not used for the VBA Enterpad operation.
If the "Load confirmation required" is switched to ON, the Enterpad's configuration software (EPConfig) will wait for this command (this is not a setting) to upload a new configuration in the memory of the Enterpad.
Using this command without the configuration software (EPConfig) linked to the VBA Enterpad will simply freeze it for less than 5 seconds OR reset the Enterpad to its factory settings if you hold the load key up to the time the status light will begin to flash (about 5 seconds).
How to choose one of two layers
The level 1 (default) allows the Enterpad to trigger macros "EP_1" to "EP_230". Selecting level 2 will trigger 230 new macros ("EP_501" to "EP_730").
By pressing one of the two keys, '1' or '2' in the shift mode, the user is able to select which layer will be active. When the second layer is active, the status light of the Enterpad is blinking. The layer 1 will be the default layer when the Enterpad is powered on.
To empty the Enterpad buffer
The 'ESC' key, when used in the shift mode, allows you to empty the Enterpad internal buffer (i.e, every pressed Enterpad key, waiting to be processed will be cleared).
In order to ensure optimal use of your Enterpad, the overlay sheet must be correctly lined up with the two guides on the protective film. The use of a relatively light weight paper will determine the degree of sensitivity needed to activate a key. Pressure should be applied near the center of the key.
If you have any questions, comments, problems or suggestions concerning this product, write to:
Cedeq Industries Inc.
5193 Montee St-Hubert
J3Y 1V8, Canada
The Enterpad™ software copyright
Copyright © 2017 by Cedeq Industries Inc. All rights reserved. The Enterpad software is protected by Canadian copyright laws and by International Agreements.
Cedeq Industries warrants the Enterpad against defects in material or workmanship for a period of one year from the date of purchase.
If the unit fails to work properly when used under normal conditions, we will repair or replace it free of charge. The defective Enterpad should be returned securely packaged, insured and postage prepaid with a copy of your sales slip to your vendor.
This warranty replaces warranties of any kind either expressed or implied. Cedeq does not warrant, guarantee or make any representations regarding the use of the Enterpad or results obtained, following its use in terms of conformity, accuracy and durability.
The Enterpad meets Canadian and American standards (ACNOR 108.8-M1983, code FCC, section 15-1989) with respect to electromagnetic radiation emissions for class A apparatus. Testing was done in conformity with ANSI C6.4-1991 procedure requirements.