The Macro Button displays a button on the user form that when clicked will run a macro.
The name of the macro to launch is set in the Macro Name property.
When using an Excel based project the macro can be VBA code that exists in a module in the VB project of the excel workbook assigned to the Excel based project.
When using a DriveWorks project there are 2 options available for writing macros:
The value must equal the name given to a macro that exists in the project; for example:
"MyMacro"
When the form control is applied the name entered will display as the caption for the form control. This can be changed by selecting the Text property.
Appearance Properties | Behavior Properties |
---|---|
Background Color | Enabled |
Font | Error Result |
Picture | Macro Argument |
Picture (Hover) | Macro Name |
Picture (Pressed) | Tab Index |
Picture Size Mode | Visible |
Picture Style | |
Text | |
Text Color | |
Text Horizontal Alignment | |
General Properties | Layout Properties |
(Metadata) | Height |
(Name) | Left |
(Tag) | Top |
Tooltip Duration | Width |
Tooltip Text |
DriveWorks Tech Tips Portal |
Shopping Basket The project allows a customer to select from a range of products and specify a quantity. This is exported to a Simple Table and then used to create a summary from where customers can see their selections, and remove an item if desired, before checking out. |
DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract. Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning. To access the portal:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |
A user form control that, when selected, will run a VBA macro.