Make form elements (combobox etc) target name (named range) available in macro
named ranges managed by form elements are only available in the sheet, not in the workbook and therefore not accessible/changeable in macros. It would be very helpful to access those variables in macros, to have more flexible abilities to trigger form element behaviour and selection of elements.
ADMIN RESPONSE
Jul 2, 2019
Already possible, see element object:
http://knowledgebase.jedox.com/doc/5_1/macro_engine/
The request referrs to the possibility to set the variables via macro. This is not possible (as confirmed by the jedox support). We would benefit from this feature in almost every project, for example to set ComboBoxes to a user based default value.
to set a initial set of variable values is something we need in most of our reports
at the moment we have at the moment. And every time we have to use some complicated workaround.
