DEDITEC video
DELIB.BAS integration in Visual Basic for Applications (VBA)
Description of the "delib.bas" integration in Visual Basic for Applications
Download and install the DELIB-Driverlibrary (continue to DELIB-Driverlibrary). You can find the needed files for VBA in the directory C:\Programme\DEDITEC\DELIB\include\delib.bas.
Start Microsoft Excel and open via menu "Extras -> Makro -> Visual Basic Editor".
| Open Visual Basic Editor |
|
Click to enlarge  |
Creation of UserForm
Create a new UserForm via menu "Einfügen -> UserForm". In the top left-hand corner of the project manager right click on "UserForm -> Datei importieren". Open in the directory C:\Programme\DEDITEC\DELIB\include the file "delib.bas" to import.
| Import of the DELIB.BAS include file |
|
Click to enlarge |
Create two buttons with the controlelements of the toolbox via menu "Ansicht -> Werkzeugsammlung".
| Create Buttons |
|
Click to enlarge |
Sample program for VBA
Double click on one of the buttons and type the sample program. In this example the left button sets the first relay of the modul to state 1 (e.g. on) and the right button restores the same relay to state 0 (e.g. off).
| Code for VBA |
|
Click to enlarge |
Finally start the UserForm via pressing "start".
| Start UserForm |
|
Click to enlarge |
