Hello,
I want to get the "enable" property value from my text field (for example named
txtText) placed on form on my Calc sheet.
I wrote a simple macro and attached it to "changed" event:
Sub test(Event)
msgbox(Event.Source.Text)
'OK, I get the text
msgbox(Event.Source.IsEnabled)
'OK, I get True
msgbox(Event.Source.dbg_properties)
'OK, this control has property "Enable"
Event.Source.Enable = False
'OK, I can assign value, the control now disabled
msgbox(Event.Source.Enable)
'I got the error: Inadmissible value or data type.Data type mismatch.
End Sub
The same behavior is for other control properties returning bool (Visible, Editable,
DesignMode) except Lock. The same behavior is for basic dialog controls properties.
Now my question: is it the bug or normal behavior?
Best regards
Mindaugas