which is working fine while I'm doing selection over a listbox with field values.
The problem:
I have created listbox (let's call "LB06") where values are calculate by the expression: Day(WeekStart(MY_DATE))&'-'&Day(WeekEnd(MY_DATE))&' '&Month(MY_DATE).
Resulting values are:
15-21 apr
13-19 mag
20-26 mag
17-23 giu
The question is:
While in the first case of listbox, I'm using [FIELDNAME] to access FIELDNAME values and do the proper selection, how can I get access to values given by the expression Day(WeekStart(MY_DATE))&'-'&Day(WeekEnd(MY_DATE))&' '&Month(MY_DATE) ?
Let's say, for instance, that I'd like to select 15-21 apr.
Since I'd like to make the proper selection on document opening, another try would be to trigger the sheet opening event (onActivateSheet) with the selection action. But in this case I also have the same problem of how to access values of a "calculated expression listbox".