Forum Discussion
Using dynamic arrays to populate named ranges for ListBox Controls is unstable - user error?.
Hi, this is my first post, and I've been pointed here by a MS365 support ambassador whose help I have exhausted. Edited to include JoeMcDaid Excel Program Manager as this seems to be your bag, Joe. ...
Thanks Joe,
I will work on that later today (Friday) UK-time and send over with a short description of the data model and the business logic that the workbook contains. Watch out for that being attached in my reply. Appreciate your time on this.
Thanks
Rory
I will work on that later today (Friday) UK-time and send over with a short description of the data model and the business logic that the workbook contains. Watch out for that being attached in my reply. Appreciate your time on this.
Thanks
Rory
Hi Joe
Time marches on and I've partially resolved this issue by moving away from Userforms and presenting the entire UI within the Excel worksheet and using Data Validation to display the results of the dynamic array formulae - which works reliably every time whereas using the controls for ComboBox., Forms and ActiveX, do not work reliably.
I wonder if you've had any further opportunity to review this issue and identify a workaround or schedule a code change to deal with the unreliability.
I may need to move the UI into a userform for Mac compatibility with other elements but I am concerned that the dynamic array formulae and Form/ActiveX controls for ListFillRange and RowSource are not going to work.
Appreciate any aupdate so I can schedule appropriate mitigation work in the right direction.
Many thanks
Rory
Time marches on and I've partially resolved this issue by moving away from Userforms and presenting the entire UI within the Excel worksheet and using Data Validation to display the results of the dynamic array formulae - which works reliably every time whereas using the controls for ComboBox., Forms and ActiveX, do not work reliably.
I wonder if you've had any further opportunity to review this issue and identify a workaround or schedule a code change to deal with the unreliability.
I may need to move the UI into a userform for Mac compatibility with other elements but I am concerned that the dynamic array formulae and Form/ActiveX controls for ListFillRange and RowSource are not going to work.
Appreciate any aupdate so I can schedule appropriate mitigation work in the right direction.
Many thanks
Rory