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:
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|
|Picture (Hover)||Macro Name|
|Picture (Pressed)||Tab Index|
|Picture Size Mode||Visible|
|Text Horizontal Alignment|
|General Properties||Layout Properties|
DriveWorks Tech Tips Portal
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.
A user form control that, when selected, will run a VBA macro.