Widgets and Controls

Simplify and expedite form controls. Query form results, without writing macros.

Calls Wingding Widgets dialog, which inserts graphical characters into the current selection of cells. The Propel template automatically detects and converts the below graphical characters to hyperlinks. See Note #1.
  • Checkboxes: Fills-in or removes checkmarks.
  • Radios: Fills-in dot and removes dots from areas immediately above and below.
  • Arrows: Left-to-right. Up-to-Down. Vice versa.
  • Buttons: Refreshes the cell or launches macros. See Note#2.
Note #1: The graphical characters are nothing more than Wingding fonts, which were first introduced by Microsoft© in 1990. Propel looks for graphical characters at the beginning or end of each cell. Checkboxes, radios, and arrows must be the first characters of a cell, and buttons must be the last character.
Note #2: The launch button calls the macro by the name within the cell. E.g. "Hello 8" does CALLMACRO("Hello") when clicked.
Several widgets are demonstrated below. The advantages of Wingdings are ease of creation, ease of copying, and ease of integration into the spreadsheet--without macro code. To query the status of a widget, use LEFT(..., 1) to read the first character.

CALLMACRO(macroname, condition, <valuetodisplay>, <monitors>)
Calls macroname if condition is TRUE and returns valuetodisplay. See Note #1.
  • macroname: Value returned by function.
  • condition: Boolean, TRUE or FALSE.
  • valuetodisplay: Value returned by function (default = "").
  • monitors: Additional range of cells that will trigger macroname to be called.
Note #1: The most common usage of CALLMACRO is in large tables. For each row of the table, one may write or record a macro (using relative coordinates) that will conditionally fire (replace text, copy cells, etc).

Last edited Apr 20, 2014 at 12:53 AM by chadspen, version 5