Remember the Last Selection

There are two approaches:

1) Save the state of the control in the woksheet custom metadata. This method will work in versoins 13, 14 and 15, but not in versions 11 or earlier (I"m not sure about version 12).

2) Save the state of the control in a textbox. This will work in all versions 11 and later, and maybe some earlier versions too.

There are some things to be aware of when using them.

Firstly, in version 11 if the result of calling a function is not displayed, and it's also not assigned to any variable, Mathcad does not calculate it. That means that if you use method 2 and put the SaveData function in a collapsed area it will not work. In version 12 and later they removed this optimization, and therefore it will work.

For the second method, if the Listbox is off screen at start-up and there is a calculation using the output from the Listbox in a collapsed area then mathcad appears to generate a new (blank) mathcad process on the windows taskbar. This problem applies only to version 12

Saving the state in the custom metadata causes another mathcad.exe process to be started. There is at least one report that in version 14 Enterprise Edition (this does not apply to the Single User Edition) this new mathcad.exe process requires an additional license, so you get a popup error every time you run the program. I don't know if this has been fixed for later service releases of version 14, but it does not occur in version 15.

Saving the state of the control in the custom metadata will not work if the control is in a referenced worksheet (because it can't see the metadata). Method 2 will work if the control, and SaveData function, are in a referenced worksheet.

Method 1 is much slower (about 6 times slower!) than method 2. This doesn't matter much if you have only one control, but it can make a big difference if you have a large number of them.