Here's a rework of that table of cell names and text values, where it is turned into a value procedure for immediate reevaluation of all those .Text values on request.
This helps to send all the data to the sheet, but needs extra work if you want to reverse the process and pull back data from the sheet to the Labels and TextBoxes.
The List_Data value procedure needed a little enhancement to serve two functions,
- returning a selected item by number n, or
- returning the total list length, if given an out of range (0) index.
RankData_ABG.aia (133.7 KB)
Proof of update:
Note that I did a bunch of component renaming to facilitate separating out Labels and Textboxes and TimePicker components into separate lists, in anticipation of two way data traffic.
Here's a start on component lists for two way traffic:
